CONCAT function equivalent

From: Fabian Santiago <fabian(dot)santiago(at)gmail(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: CONCAT function equivalent
Date: 2014-05-17 15:03:35
Message-ID: CAP4E920joZPxFc_6pUxgcMzNufj6R_ye1oD40nB=J_ENRamxYw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

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.

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Joe Conway 2014-05-17 15:25:03 Re: CONCAT function equivalent
Previous Message Bruce Momjian 2014-05-15 21:56:47 Re: Restrict number of connections to specific table