From: | Joe Conway <mail(at)joeconway(dot)com> |
---|---|
To: | Fabian Santiago <fabian(dot)santiago(at)gmail(dot)com>, pgsql-novice(at)postgresql(dot)org |
Subject: | Re: CONCAT function equivalent |
Date: | 2014-05-17 15:25:03 |
Message-ID: | 53777F4F.8050609@joeconway.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
-----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-----
From | Date | Subject | |
---|---|---|---|
Next Message | Fabian Santiago | 2014-05-17 19:26:02 | Re: CONCAT function equivalent |
Previous Message | Fabian Santiago | 2014-05-17 15:03:35 | CONCAT function equivalent |