Why does 

   select jsonb_set('{"foo": 1}'::jsonb, '{bar}', to_jsonb(null::int), true)

return NULL when all it should do is to add a second key?

I would expect {"foo": 1, "bar": null} or no change at all to the original JSON 
value, but not that the whole JSON is set to null. 

In the original case the new value to be set was the result of an expression, 
not a "hardcoded" null value.
 
Thomas





Reply via email to