----- Original Message -----
> From: Andreas Kretschmer <[email protected]>
> To: [email protected]
> Cc:
> Sent: Saturday, 30 May 2015, 13:10
> Subject: Re: [GENERAL] replacing jsonb field value
>
> Michael Paquier <[email protected]> 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).
--
Sent via pgsql-general mailing list ([email protected])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
