git.postgresql.org Git - postgresql.git/commit

git projects / postgresql.git / commit

Allow json{b}_strip_nulls to remove null array elements

author Andrew Dunstan <andrew@dunslane.net>

Wed, 5 Mar 2025 14:50:34 +0000 (09:50 -0500)

committer Andrew Dunstan <andrew@dunslane.net>

Wed, 5 Mar 2025 15:04:02 +0000 (10:04 -0500)

commit 4603903d294bbdd644afecf9b5970827db6d1ff5

tree 29212352a8e09f5076b03c752976b416eeba8014 tree

parent 5ead85fbc81162ab1594f656b036a22e814f96b3 commit | diff

Allow json{b}_strip_nulls to remove null array elements

An additional paramater ("strip_in_arrays") is added to these functions.
It defaults to false. If true, then null array elements are removed as
well as null valued object fields. JSON that just consists of a single
null is not affected.

Author: Florents Tselai <florents.tselai@gmail.com>

Discussion: https://postgr.es/m/4BCECCD5-4F40-4313-9E98-9E16BEB0B01D@gmail.com

doc/src/sgml/func.sgml diff | blob | blame | history

src/backend/catalog/system_functions.sql diff | blob | blame | history

src/backend/utils/adt/jsonfuncs.c diff | blob | blame | history

src/include/catalog/pg_proc.dat diff | blob | blame | history

src/test/regress/expected/json.out diff | blob | blame | history

src/test/regress/expected/jsonb.out diff | blob | blame | history

src/test/regress/sql/json.sql diff | blob | blame | history

src/test/regress/sql/jsonb.sql diff | blob | blame | history

This is the main PostgreSQL git repository.

RSS Atom