Re: replacing jsonb field value

Поиск
Список
Период
Сортировка
От Glyn Astill
Тема Re: replacing jsonb field value
Дата
Msg-id 542773010.2791490.1433022308833.JavaMail.yahoo@mail.yahoo.com
обсуждение исходный текст
Ответ на Re: replacing jsonb field value  (Andreas Kretschmer <akretschmer@spamfence.net>)
Ответы Re: replacing jsonb field value
Список pgsql-general



----- Original Message -----
> From: Andreas Kretschmer <akretschmer@spamfence.net>
> To: pgsql-general@postgresql.org
> Cc:
> Sent: Saturday, 30 May 2015, 13:10
> Subject: Re: [GENERAL] replacing jsonb field value
>
> Michael Paquier <michael.paquier@gmail.com> wrote:
>
>>
>>  Append the new value to it the existing field, jsonb has as property
>>  to enforce key uniqueness, and uses the last value scanned for a given
>>  key.
>
> can you show a simple example, how to append a jsonb to an jsonb-field?
> Maybe i'm blind, but i can't find how it works.
>
> Thx.
>

>
> Andreas

Prior to 9.5 you can't, I think you have to use something like jsonb_each to unwrap it then wrap it back up again.

The jsonbx extension, which I believe is what ended up in 9.5 has a simple concatenate function (here:
https://github.com/erthalion/jsonbx),I also had a go (here: https://github.com/glynastill/pg_jsonb_opx). 

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

Предыдущее
От: Melvin Davidson
Дата:
Сообщение: Re: How to retrieve Comment text using SQL, not psql?
Следующее
От: Andres Freund
Дата:
Сообщение: Re: [HACKERS] Re: 9.4.1 -> 9.4.2 problem: could not access status of transaction 1