Date: Wed, 25 Apr 2018 18:55:44 -0400
From: Bruce Momjian <bruce@momjian.us>
To: roy@oneaudience.com, pgsql-docs@lists.postgresql.org
Subject: Re: how does jsonb_set work?
Message-ID: <20180425225544.GA24468@momjian.us>
References: <152379992223.31235.17882617912768220310@wrigleys.postgresql.org>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
In-Reply-To: <152379992223.31235.17882617912768220310@wrigleys.postgresql.org>
User-Agent: Mutt/1.5.23 (2014-03-12)
Precedence: bulk

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 +