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
Those three instructions were sent to postgresql
1- this one is ok, set the field to an empty object
update table1 set history=‘{}’
2- this one is ok, creates a key q1 initialized at an empty object
update table1 set history=jsonb_set(history,’{q1}’, ‘{}’)
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))
this is on postgresql 5.5
Best regards
Pascal BARBEDOR
tel 01 45 34 55 25
mob 06 82 32 69 63
tel 01 46 23 86 74
fax 09 72 42 01 93