Horton
Menu

Re: jsonb_strip_nulls with arrays?

Andrew Dunstan <andrew@dunslane.net>

View thread
From: Andrew Dunstan <andrew@dunslane.net>
To: Florents Tselai <florents.tselai@gmail.com>
Cc: PostgreSQL Hackers <pgsql-hackers@lists.postgresql.org>
Date: 2025-01-08T16:45:02Z
Lists: pgsql-hackers 
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.


cheers


andrew


--
Andrew Dunstan
EDB: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