From: | "Aaron Bono" <postgresql(at)aranya(dot)com> |
---|---|
To: | "George Handin" <postgresql(at)dafunks(dot)com> |
Cc: | pgsql-sql(at)postgresql(dot)org |
Subject: | Re: Concat two fields into one at runtime |
Date: | 2006-06-08 15:53:50 |
Message-ID: | bf05e51c0606080853o6f349107u868a68224e2eed5b@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
select id, first || ' ' || last
from mytable;
On 6/8/06, George Handin <postgresql(at)dafunks(dot)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
>
From | Date | Subject | |
---|---|---|---|
Next Message | Kenneth B Hill | 2006-06-08 15:54:01 | Re: Concat two fields into one at runtime |
Previous Message | Kenneth B Hill | 2006-06-08 15:51:48 | Re: Query to return modified results at runtime? |