Postgres Pro
Downloads
Home   >   mailing lists

Re: Concat two fields into one at runtime - Mailing list pgsql-sql

From Aaron Bono
Subject Re: Concat two fields into one at runtime
Date
Msg-id bf05e51c0606080853o6f349107u868a68224e2eed5b@mail.gmail.com
Whole thread Raw
In response to Concat two fields into one at runtime  (George Handin <postgresql@dafunks.com>)
List pgsql-sql
Tree view
select id, first || ' ' || last
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 by date:

Previous
From: Kenneth B Hill
Date:
Subject: Re: Query to return modified results at runtime?
Next
From: Bricklen Anderson
Date:
Subject: Re: Concat two fields into one at runtime