Re: CONCAT function equivalent

From: David G Johnston <david(dot)g(dot)johnston(at)gmail(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: Re: CONCAT function equivalent
Date: 2014-05-17 15:03:29
Message-ID: 1400339009183-5804327.post@n5.nabble.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Korry Douglas 2014-05-17 20:04:14 Re: CONCAT function equivalent
Previous Message Fabian Santiago 2014-05-17 14:20:59 CONCAT function equivalent