Re: CONCAT function equivalent

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

On 05/17/2014 08:03 AM, 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.

You mean like this?

select version();
                                                     version

-
-----------------------------------------------------------------------------------------------------------------
 PostgreSQL 8.4.19 on x86_64-unknown-linux-gnu, compiled by GCC gcc
(Ubuntu/Linaro 4.7.3-1ubuntu1) 4.7.3, 64-bit
(1 row)

select settings || 'default_language:' || default_language || ';'
from (values ('default_foo:foo;','English'))
as t(settings, default_language);
                 ?column?
- -------------------------------------------
 default_foo:foo;default_language:English;
(1 row)

HTH,

Joe

- --
Joe Conway
credativ LLC: http://www.credativ.us
Linux, PostgreSQL, and general Open Source
Training, Service, Consulting, & 24x7 Support
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.14 (GNU/Linux)
Comment: Using GnuPG with Thunderbird - http://www.enigmail.net/

iQIcBAEBAgAGBQJTd39OAAoJEDfy90M199hlit0P/iLoEPe98ktCk1HDJchGzEeK
iKtMZHPIjJ4VNaxellPHrkY2yravd06ejKL+eHrytPmm+l1UCka2FzC8Gavvhbam
cbjsm1My+q22J6wCpt2b8tVgl3RibLCol8k/rMwQFVMk1WRMFSAJtQOeVASxI9Ms
9xmV82w+zGbCrHPzxINo3EHpNuoDdz1SKqVPCP93CMeQc6qqTqolPL4w+B9405/V
qPyCHoAfCBw3CGh/cmJ2iu7qCGhdHydGTzzYeTf48N5hXq7903yUF/jd1Nm3IbRJ
TdB7mbUFCExv7R/7FQ5oRj4ELMv5nz9S92qlRcj0qEpuBtSfHtM+72h7Wl4jq66e
JKLyOfakszbb59VDZCIsgofGGiF2Vf7eiMwi+doWsSVvogVukOF/dnL5Py1LG4n4
2XyxKzyM+ddinWAT5qLv9zFUQ6KQZo64dRyxdFscWJneQ6nOmyMMBA743U6JN+wQ
/VivlVQJOxlf2V7DffRvV6BsZBgyeD6ri98YnVeO0lz+mKIe3PSxylPSaBljYTRz
pXYEOYAAXxYxkw6V047vYY3/2050jOzYBMPsmzvWxLN6Bgl1IHhk/8mUbQjqVpQq
CVFgRXgBb0AJeDKbmUEcpWS+qd9UO0mDYGs0cvHbcn89LYIPvENs6IIgxM1gXRUM
BmRUwP0M15lfckjAd2fX
=H/vF
-----END PGP SIGNATURE-----