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

author	Andrew Dunstan <andrew@dunslane.net>
	Fri, 12 Dec 2014 14:00:43 +0000 (09:00 -0500)
committer	Andrew Dunstan <andrew@dunslane.net>
	Fri, 12 Dec 2014 14:00:43 +0000 (09:00 -0500)
commit	237a8824430c607fce1eafde0c625744d50a455c
tree	e8f0fcf9806697ef2754e83b24815a2c97af363d	tree
parent	b1332e98c441b40300670f55a4303bf69cd8b226	commit \| diff

Add json_strip_nulls and jsonb_strip_nulls functions.

The functions remove object fields, including in nested objects, that
have null as a value. In certain cases this can lead to considerably
smaller datums, with no loss of semantic information.

Andrew Dunstan, reviewed by Pavel Stehule.

This is the main PostgreSQL git repository.

RSS Atom

doc/src/sgml/func.sgml		diff \| blob \| blame \| history
src/backend/utils/adt/jsonfuncs.c		diff \| blob \| blame \| history
src/include/catalog/catversion.h		diff \| blob \| blame \| history
src/include/catalog/pg_proc.h		diff \| blob \| blame \| history
src/include/utils/json.h		diff \| blob \| blame \| history
src/test/regress/expected/json.out		diff \| blob \| blame \| history
src/test/regress/expected/json_1.out		diff \| blob \| blame \| history
src/test/regress/expected/jsonb.out		diff \| blob \| blame \| history
src/test/regress/expected/jsonb_1.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