how does jsonb_set work?

Started by PG Bug reporting formabout 8 years ago2 messagesdocs
Jump to latest
#1PG Bug reporting form
noreply@postgresql.org

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

#2Bruce Momjian
bruce@momjian.us
In reply to: PG Bug reporting form (#1)
Re: how does jsonb_set work?

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 +