Re: replacing jsonb field value

----- 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).