Re: replacing jsonb field value - Mailing list pgsql-general

From Andreas Kretschmer
Subject Re: replacing jsonb field value
Date
Msg-id 20150531082823.GA9838@tux
Whole thread Raw
In response to Re: replacing jsonb field value  (Glyn Astill <glynastill@yahoo.co.uk>)
List pgsql-general
Glyn Astill <glynastill@yahoo.co.uk> wrote:

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

Thanks.


Andreas
--
Really, I'm not out to destroy Microsoft. That will just be a completely
unintentional side effect.                              (Linus Torvalds)
"If I was god, I would recompile penguin with --enable-fly."   (unknown)
Kaufbach, Saxony, Germany, Europe.              N 51.05082°, E 13.56889°


pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Efficient sorting the results of a join, without denormalization
Next
From: Zenaan Harkness
Date:
Subject: advocating LTS release and feature-train release cycles