Re: jsonb_strip_nulls with arrays?

> On 18 Jan 2025, at 11:51 AM, Florents Tselai <florents.tselai@gmail.com> wrote:
> 
> 
> 
>> On 8 Jan 2025, at 6:45 PM, Andrew Dunstan <andrew@dunslane.net> wrote:
>> 
>> 
>> 
>> On 2024-09-17 Tu 4:53 PM, Florents Tselai wrote:
>>> 
>>>> We could, if we're going to do anything at all in this area. Another possibility would be to provide a second optional parameter for json{b}_strip_nulls. That's probably a better way to go.
>>>> 
>>> Here's a patch that adds that argument (only for jsonb; no json implementation yet)
>>> 
>>> 
>> 
>> I think it looks sane. We're not stripping a top level null, which is one thing I looked out for.
>> 
>> I think we need a json implementation as well, though.
>> 
>> 
>> 
> Thanks for having a Look, Andrew; 
> if there aren’t any other objections, I’ll come back with a json implementation too. 

Attached is a v2 patch with the missing json implementation. 
jsonb one remains the same.


>> 
>> cheers
>> 
>> 
>> 
>> andrew
>> 
>> 
>> 
>> --
>> Andrew Dunstan
>> EDB: https://www.enterprisedb.com <https://www.enterprisedb.com/>