Re: jsonb_strip_nulls with arrays?

On 2025-02-19 We 4:23 PM, Florents Tselai wrote:
>
>
>> 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.



Please add this to the next Commitfest at 
https://commitfest.postgresql.org/52/


cheers


andrew


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