From: | Darren Ferguson <darren(at)crystalballinc(dot)com> |
---|---|
To: | Dan Ostrowski <dan(at)triad-dev(dot)com> |
Cc: | postgres <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: Major Problem with locale |
Date: | 2002-10-01 23:15:59 |
Message-ID: | Pine.LNX.4.44.0210011915220.29990-100000@thread.crystalballinc.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Postgres supports concat with the ||
so you can do the following
Select first_name||' '||last_name AS full_name FROM users;
HTH
On Tue, 1 Oct 2002, Dan Ostrowski wrote:
> Does postgres support the "concat" functionality? I looked in the
> interactive docs but couldn't find it... i am still looking but if you
> know one way or the other could you tell me?
>
> I am just checking for compatiblity... i want to "SELECT
> CONCAT(table.somefield,' ',table.somefield) AS FullName FROM table"
>
> is this supported or do you use another notation.
>
> thanks very much all..
> dan
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to majordomo(at)postgresql(dot)org so that your
> message can get through to the mailing list cleanly
>
--
Darren Ferguson
From | Date | Subject | |
---|---|---|---|
Next Message | Dan Ostrowski | 2002-10-01 23:18:41 | Re: Major Problem with locale |
Previous Message | Mark Wilson | 2002-10-01 22:27:10 | database session variables |