Re: CONCAT function equivalent

Поиск
Список
Период
Сортировка
От Fabian Santiago
Тема Re: CONCAT function equivalent
Дата
Msg-id CAP4E921FQ4EpxH+ugonZobFS9f+ryhZ0MfBgqRkUo6sKfXYieQ@mail.gmail.com
обсуждение исходный текст
Ответ на Re: CONCAT function equivalent  (David G Johnston <david.g.johnston@gmail.com>)
Список pgsql-admin
I upgraded to v9.1 and that solved a lot of my hurt. Thanks. 



On Sat, May 17, 2014 at 11:03 AM, David G Johnston <david.g.johnston@gmail.com> wrote:
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



--
Sincerely,

Fabian S.
862-432-2373

В списке pgsql-admin по дате отправления:

Предыдущее
От: Fabian Santiago
Дата:
Сообщение: Re: CONCAT function equivalent
Следующее
От: Steve Crawford
Дата:
Сообщение: Re: Regarding server sizing for postgres database