Re: Concat two fields into one at runtime
От
Aaron Bono
Тема
Re: Concat two fields into one at runtime
Дата
Msg-id
bf05e51c0606080853o6f349107u868a68224e2eed5b@mail.gmail.com
Ответ на
Concat two fields into one at runtime (George Handin)
Список
Дерево обсуждения
Concat two fields into one at runtime George Handin <postgresql@dafunks.com>
Re: Concat two fields into one at runtime Kenneth B Hill <ken@scottshill.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 "Aaron Bono" <postgresql@aranya.com>
select id, first || ' ' || last
from mytable;
from mytable;
On 6/8/06, George Handin <postgresql@dafunks.com> wrote:
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
---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings
В списке pgsql-sql по дате отправления
