Concat two fields into one at runtime

Поиск
Список
Период
Сортировка
От George Handin
Тема Concat two fields into one at runtime
Дата
Msg-id 44884736.3080309@dafunks.com
обсуждение исходный текст
Ответы Re: Concat two fields into one at runtime  ("Aaron Bono" <postgresql@aranya.com>)
Re: Concat two fields into one at runtime  (Bricklen Anderson <banderson@presinet.com>)
Re: Concat two fields into one at runtime  (Oisin Glynn <me@oisinglynn.com>)
Re: Concat two fields into one at runtime  (Kenneth B Hill <ken@scottshill.com>)
Список pgsql-sql
Is there a way using built-in PostgreSQL functions to combine two data 
fields into a single field at runtime when querying data?

For example, the query now returns:

id    first    last
---   -------  ----------
1     Goerge   Handin
2     Joe      Rachin

I'd like it to return:

id    name
---   -------------------
1     George Handin
2     Joe Rachin


В списке pgsql-sql по дате отправления:

Предыдущее
От: Richard Broersma Jr
Дата:
Сообщение: Re: Query to return modified results at runtime?
Следующее
От: George Handin
Дата:
Сообщение: Re: Query to return modified results at runtime?