Re: how does jsonb_set work?

From: Bruce Momjian <bruce(at)momjian(dot)us>
To: roy(at)oneaudience(dot)com, pgsql-docs(at)lists(dot)postgresql(dot)org
Subject: Re: how does jsonb_set work?
Date: 2018-04-25 22:55:44
Message-ID: 20180425225544.GA24468@momjian.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-docs

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(at)momjian(dot)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 +

In response to

Browse pgsql-docs by date

  From Date Subject
Next Message Michael Paquier 2018-04-26 01:59:10 Re: document json[b] limitation
Previous Message Oleg Bartunov 2018-04-25 19:42:25 Re: document json[b] limitation