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@postgresql.org so that your
> message can get through to the mailing list cleanly
>
--
Darren Ferguson