----- Original Message ----- > From: Andreas Kretschmer <akretschmer@xxxxxxxxxxxxx> > To: pgsql-general@xxxxxxxxxxxxxx > Cc: > Sent: Saturday, 30 May 2015, 13:10 > Subject: Re: replacing jsonb field value > > Michael Paquier <michael.paquier@xxxxxxxxx> 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 (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
