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

git projects / postgresql.git / commit

Add json_strip_nulls and jsonb_strip_nulls functions.

author Andrew Dunstan <andrew@dunslane.net>

2014年12月12日 14:00:43 +0000 (09:00 -0500)

committer Andrew Dunstan <andrew@dunslane.net>

2014年12月12日 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.

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

This is the main PostgreSQL git repository.

RSS Atom