Re: CONCAT function equivalent - Mailing list pgsql-admin

From David G Johnston
Subject Re: CONCAT function equivalent
Date
Msg-id 1400339009183-5804327.post@n5.nabble.com
Whole thread Raw
In response to CONCAT function equivalent  (Fabian Santiago <fabian.santiago@gmail.com>)
Responses Re: CONCAT function equivalent  (Fabian Santiago <fabian.santiago@gmail.com>)
List pgsql-admin
Fabian Santiago wrote
> Hello,
>
> Is there an equivalent command (string) for this example:
>
> UPDATE domain SET settings=CONCAT(settings, 'default_language:',
> defaultlanguage, ';');
>
> that works and accomplishes the same thing in postgresql v8.4? Thanks.
>
> --
> Sincerely,
>
> Fabian S.

Not in core or contrib

Could write one relatively easily in 9.0 but not sure how you'd manage in
8.4

8.4 is also going out of support soon

Coalesce and || are your tools if you stick to 8.4

David J.





--
View this message in context: http://postgresql.1045698.n5.nabble.com/CONCAT-function-equivalent-tp5804325p5804327.html
Sent from the PostgreSQL - admin mailing list archive at Nabble.com.


pgsql-admin by date:

Previous
From: Fabian Santiago
Date:
Subject: CONCAT function equivalent
Next
From: Korry Douglas
Date:
Subject: Re: CONCAT function equivalent