SQLсервер в Linux -самостоятельное освоение пакета

Листинг 5 4 Конкатенация строк

Листинг 5.4. Конкатенация строк

booktown=# SELECT 'The Title: ' | title || ', by ' |

booktown-# first_name || ' ' II lastjiame AS bookjinfo

booktown-# FROM books NATURAL JOIN authors AS a (authorjd) LIMIT 3;


The Title: The Shining, by Stephen King

The Title: Dune, by Frank Herbert

The Title: 2001: A Space Odyssey, by Arthur C. Clarke

(3 rows)

Содержание  Назад  Вперед