Received: from malur.postgresql.org ([217.196.149.56])
 by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from
 <pgsql-admin-owner+M42469=pgsql+2Dadmin=arkaria.postgresql.org@postgresql.org>)
 id 1WlkqI-0008QP-HZ
 for pgsql-admin@arkaria.postgresql.org; Sat, 17 May 2014 20:04:26 +0000
Received: from localhost ([127.0.0.1] helo=postgresql.org)
 by malur.postgresql.org with smtp (Exim 4.80) (envelope-from
 <pgsql-admin-owner+M42469=pgsql+2Dadmin=arkaria.postgresql.org@postgresql.org>)
 id 1WlkqH-0003G5-AF
 for pgsql-admin@arkaria.postgresql.org; Sat, 17 May 2014 20:04:25 +0000
Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29])
 by malur.postgresql.org with esmtp (Exim 4.80)
 (envelope-from <korry.douglas@enterprisedb.com>) id 1WlkqF-0003Fw-71
 for pgsql-admin@postgresql.org; Sat, 17 May 2014 20:04:23 +0000
Received: from mail-qg0-f54.google.com ([209.85.192.54])
 by magus.postgresql.org with esmtp (Exim 4.80)
 (envelope-from <korry.douglas@enterprisedb.com>) id 1WlkqC-00087I-72
 for pgsql-admin@postgresql.org; Sat, 17 May 2014 20:04:22 +0000
Received: by mail-qg0-f54.google.com with SMTP id q108so6318531qgd.41
 for <pgsql-admin@postgresql.org>; Sat, 17 May 2014 13:04:18 -0700 (PDT)
X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed;
 d=1e100.net; s=20130820;
 h=x-gm-message-state:message-id:date:from:user-agent:mime-version:to
 :cc:subject:references:in-reply-to:content-type;
 bh=U47X/E9OOgbyDuyrsjYjHCUeDzc7KGOxHnMxL0HkaXc=;
 b=HswPZwpNIlnNL3gF92Am4TsfK13nF7vV7KcF+oaFoURx6OMC8csue5imq/JM4SAf6E
 vm25kp/oVativyNgVD5J+f7wKsEWk/apG8RBUo/8kXBI1XaG4uwX9dVUGmLRz2Z8vtmU
 F42Pe66s+YvAtIhZ0ZbSttgw2hZi6OMJNV2sApeZ5OqKUAM/SVrIUOkcer/nDWcu40td
 VU+vqn889r/OpFrumIx2ZkpNGyGGR0RhC+DGqrpi8ZFX2Wu2u967qhL89/8XVDImzMOJ
 qPewh6qUl/tbHyO1SgRXd6Sted10am263rHUWYqtBphF80oJW4aOuT0M8p/Ve7fZzHkh
 PMQQ==
X-Gm-Message-State: 
 ALoCoQlkA+Aa7eRP5tXT73y6qa5rKkrleFud3AsFF95HBZH7Bt9sdSTa7zyKOBPS7rH5hHPrqmiY
X-Received: by 10.140.81.74 with SMTP id e68mr34674156qgd.77.1400357058456;
 Sat, 17 May 2014 13:04:18 -0700 (PDT)
Received: from MegaMac.local (va-76-4-65-131.sta.embarqhsd.net. [76.4.65.131])
 by mx.google.com with ESMTPSA id
 m7sm19226253qao.20.2014.05.17.13.04.17 for <multiple recipients>
 (version=TLSv1 cipher=ECDHE-RSA-RC4-SHA bits=128/128);
 Sat, 17 May 2014 13:04:18 -0700 (PDT)
Message-ID: <5377C0BE.3050102@enterprisedb.com>
Date: Sat, 17 May 2014 16:04:14 -0400
From: Korry Douglas <korry.douglas@enterprisedb.com>
User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10.9;
 rv:17.0) Gecko/20130509 Thunderbird/17.0.6
MIME-Version: 1.0
To: Fabian Santiago <fabian.santiago@gmail.com>
CC: pgsql-admin@postgresql.org
Subject: Re: CONCAT function equivalent
References: 
 <CAP4E9207D0GveszpGJAiLYFBYO4XEnQtudZWqkfpk9zwdkrhGg@mail.gmail.com>
In-Reply-To: 
 <CAP4E9207D0GveszpGJAiLYFBYO4XEnQtudZWqkfpk9zwdkrhGg@mail.gmail.com>
Content-Type: multipart/alternative;
 boundary="------------050102030702010801050803"
X-Pg-Spam-Score: -1.9 (-)
List-Archive: <http://archives.postgresql.org/pgsql-admin>
List-Help: <mailto:majordomo@postgresql.org?body=help>
List-ID: <pgsql-admin.postgresql.org>
List-Owner: <mailto:pgsql-admin-owner@postgresql.org>
List-Post: <mailto:pgsql-admin@postgresql.org>
List-Subscribe: <mailto:majordomo@postgresql.org?body=sub%20pgsql-admin>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-admin>
X-Mailing-List: pgsql-admin
Precedence: bulk
Sender: pgsql-admin-owner@postgresql.org

This is a multi-part message in MIME format.
--------------050102030702010801050803
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 7bit

> 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.

The concatenation operator is available in 8.4, is there some reason 
that won't work for you?

    UPDATE domain SET settings = settings || 'default_language:' ||
    defaultlanguage || ';';


    -- Korry


--------------050102030702010801050803
Content-Type: text/html; charset=UTF-8
Content-Transfer-Encoding: 7bit

<html>
  <head>
    <meta content="text/html; charset=UTF-8" http-equiv="Content-Type">
  </head>
  <body bgcolor="#FFFFFF" text="#000000">
    <blockquote
cite="mid:CAP4E9207D0GveszpGJAiLYFBYO4XEnQtudZWqkfpk9zwdkrhGg@mail.gmail.com"
      type="cite">
      <div dir="ltr">Is there an equivalent command (string) for this
        example:
        <div><br>
        </div>
        <div>UPDATE domain SET settings=CONCAT(settings,
          'default_language:', defaultlanguage, ';');</div>
        <div><br>
        </div>
        <div>that works and accomplishes the same thing in postgresql
          v8.4? Thanks.<br>
        </div>
      </div>
    </blockquote>
    <br>
    The concatenation operator is available in 8.4, is there some reason
    that won't work for you?<br>
    <blockquote>UPDATE domain SET settings = settings ||
      'default_language:' || defaultlanguage || ';';<br>
    </blockquote>
    <br>
    <blockquote>-- Korry<br>
    </blockquote>
  </body>
</html>

--------------050102030702010801050803--