bug in jsonb_set porstgresql 5.5

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

http://www.blset.com
tel 01 46 23 86 74
fax 09 72 42 01 93