Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1Wlg9A-0007oO-1E for pgsql-admin@arkaria.postgresql.org; Sat, 17 May 2014 15:03:36 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.80) (envelope-from ) id 1Wlg99-0001JK-8T for pgsql-admin@arkaria.postgresql.org; Sat, 17 May 2014 15:03:35 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1Wlg98-0001J9-HH for pgsql-admin@postgresql.org; Sat, 17 May 2014 15:03:34 +0000 Received: from sam.nabble.com ([216.139.236.26]) by magus.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1Wlg95-0002kN-9K for pgsql-admin@postgresql.org; Sat, 17 May 2014 15:03:34 +0000 Received: from [192.168.236.26] (helo=sam.nabble.com) by sam.nabble.com with esmtp (Exim 4.72) (envelope-from ) id 1Wlg93-0004AO-C8 for pgsql-admin@postgresql.org; Sat, 17 May 2014 08:03:29 -0700 Date: Sat, 17 May 2014 08:03:29 -0700 (PDT) From: David G Johnston To: pgsql-admin@postgresql.org Message-ID: <1400339009183-5804327.post@n5.nabble.com> In-Reply-To: References: Subject: Re: CONCAT function equivalent MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Pg-Spam-Score: 0.8 (/) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-admin Precedence: bulk Sender: pgsql-admin-owner@postgresql.org 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. -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin