Re: jsonb_strip_nulls with arrays?

Florents Tselai <florents.tselai@gmail.com>

From: Florents Tselai <florents.tselai@gmail.com>
To: Andrew Dunstan <andrew@dunslane.net>
Cc: pgsql-hackers <pgsql-hackers@lists.postgresql.org>
Date: 2025-01-18T09:51:22Z
Lists: pgsql-hackers

> 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. 
> cheers
> 
> 
> 
> andrew
> 
> 
> 
> --
> Andrew Dunstan
> EDB: https://www.enterprisedb.com <https://www.enterprisedb.com/>

Commits

Same data as JSON: GET /api/v1/messages/:b64id/commits the thread's linked commits as JSON, with link sources. API reference →
  1. Allow json{b}_strip_nulls to remove null array elements