Thread: how does jsonb_set work?
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/10/static/functions-json.html Description: the documentation is missing some information how does the jsonb_set function work? does it create a whole new json and updates it in the column? or it actually only updates the specific key in "path" thanks
On Sun, Apr 15, 2018 at 01:45:22PM +0000, PG Doc comments form wrote: > The following documentation comment has been logged on the website: > > Page: https://www.postgresql.org/docs/10/static/functions-json.html > Description: > > the documentation is missing some information > > how does the jsonb_set function work? > does it create a whole new json and updates it in the column? or it actually > only updates the specific key in "path" jsonb_set() is a function that returns a JSONB value with the fields changed. It is up to you to assign it to a column. -- Bruce Momjian <bruce@momjian.us> http://momjian.us EnterpriseDB http://enterprisedb.com + As you are, so once was I. As I am, so you will be. + + Ancient Roman grave inscription +