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

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

This is the main PostgreSQL git repository.

RSS Atom

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