Since it is only a key inside the json object which is assigned the null value, does it mean it is impossible to have null values inside the jsonb object ?
On Thu, Feb 22, 2018 at 6:38 AM, Pascal Barbedor <pbarbedor@blset.com> wrote:
Hello
I noticed a problem with a jsonb field and jsonb_set function
- table1 is a table with history a jsonb field, and obs a text field which is null
[...]
3- this one resets completely the jsonb field, not only the key obs is not set to null but the entire jsonb field is now null
update table1 set history=jsonb_set(history,’{q1,obs}’, to_jsonb(obs))
Working as designed - jsonb_set and to_jsonb are both defined as "NULL ON NULL INPUT (i.e., STRICT)" - since "obs [is] a text field which is null" the final result of the function call is NULL.