Re: Major Problem with locale

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