Re: Why does jsonb_set() remove non-mentioned keys?

Gianni Ceccarelli schrieb am 05.07.2019 um 10:00:
>> strict functions with sql null inputs yield sql null output without
>> even executing the function
> 
> So when the SQL-level executor sees a call to any function declared
> strict with some NULL parameters, it doesn't call the function at
> all. `whatever_my_function('a string',1234,NULL)` is always `NULL`
> 

Ah, I see. Thanks for the clarification

Then I would question if declaring jsonb_set as "strict" makes sense

Thomas