From: Korry Douglas <korry.douglas@enterprisedb.com>
To: Fabian Santiago <fabian.santiago@gmail.com>
Cc: pgsql-admin@postgresql.org
Subject: Re: CONCAT function equivalent
Date: Sat, 17 May 2014 16:04:14 -0400
Message-ID: <5377C0BE.3050102@enterprisedb.com> (raw)
In-Reply-To: <CAP4E9207D0GveszpGJAiLYFBYO4XEnQtudZWqkfpk9zwdkrhGg@mail.gmail.com>
References: <CAP4E9207D0GveszpGJAiLYFBYO4XEnQtudZWqkfpk9zwdkrhGg@mail.gmail.com>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-admin>
> 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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: korry.douglas@enterprisedb.com, fabian.santiago@gmail.com
Subject: Re: CONCAT function equivalent
In-Reply-To: <5377C0BE.3050102@enterprisedb.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox