On 18 Jan 2025, at 11:51 AM, Florents Tselai <florents.tse...@gmail.com> wrote:
On 8 Jan 2025, at 6:45 PM, Andrew Dunstan <and...@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.
|
v2-0001-jsonb_strip_nulls-jsonb-bool-wip.patch
Description: Binary data
v2-0002-Add-docs-for-strip_in_arrays-argument.patch
Description: Binary data
v2-0003-Add-implementation-for-json_strip_nulls-json-bool.patch
Description: Binary data