Re: Why does jsonb_set() remove non-mentioned keys? - Mailing list pgsql-general

From Thomas Kellerer
Subject Re: Why does jsonb_set() remove non-mentioned keys?
Date
Msg-id e71033e4-eadf-5235-cc1b-9c54b7bd827c@gmx.net
Whole thread Raw
In response to Re: Why does jsonb_set() remove non-mentioned keys?  (Gianni Ceccarelli <dakkar@thenautilus.net>)
Responses Re: Why does jsonb_set() remove non-mentioned keys?  ("Peter J. Holzer" <hjp-pgsql@hjp.at>)
List pgsql-general
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



pgsql-general by date:

Previous
From: Simon T
Date:
Subject: Vacuum and freeing dead rows
Next
From: Andrey Sychev
Date:
Subject: Re: Error: rows returned by function are not all of the same row type