BUG #15140: Incorrect jsonb_set behavoir - Mailing list pgsql-bugs

From PG Bug reporting form
Subject BUG #15140: Incorrect jsonb_set behavoir
Date
Msg-id 152266540508.1442.16790414733320933622@wrigleys.postgresql.org
Whole thread Raw
Responses Re: BUG #15140: Incorrect jsonb_set behavoir
List pgsql-bugs
The following bug has been logged on the website:

Bug reference:      15140
Logged by:          Ivan Panchenko
Email address:      i.panchenko@postgrespro.ru
PostgreSQL version: 10.3
Operating system:   any
Description:

First. Impossible to create a nested structure for a path with more than one
new keys.

postgres => select jsonb_set('{}'::jsonb, array['x', 'y'],
to_jsonb(1::text), true);
 jsonb_set
-----------
 {}
(1 строка)

Expected {"x": { "y" : "1" }} 

Second. Setting a NULL value nullifies the whole JSON 

postgres=> select jsonb_set('{}'::jsonb, array['x'], null, true);
 jsonb_insert
--------------
 
(1 строка)

Expected { "x" : null }


pgsql-bugs by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: BUG #15112: Unable to run pg_upgrade with earthdistance extension
Next
From: Dmitry Dolgov
Date:
Subject: Re: BUG #15140: Incorrect jsonb_set behavoir