Re: replacing jsonb field value

----- Original Message -----
> From: Andreas Kretschmer <akretschmer(at)spamfence(dot)net>
> To: pgsql-general(at)postgresql(dot)org
> Cc:
> Sent: Saturday, 30 May 2015, 13:10
> Subject: Re: [GENERAL] replacing jsonb field value
>
> Michael Paquier <michael(dot)paquier(at)gmail(dot)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).