projects / postgresql.git / commit
? search:
summary | shortlog | log | commit | commitdiff | tree
(parent: b1332e9) | patch
Add json_strip_nulls and jsonb_strip_nulls functions.
authorAndrew Dunstan <andrew@dunslane.net>
Fri, 12 Dec 2014 14:00:43 +0000 (09:00 -0500)
committerAndrew Dunstan <andrew@dunslane.net>
Fri, 12 Dec 2014 14:00:43 +0000 (09:00 -0500)
commit237a8824430c607fce1eafde0c625744d50a455c
treee8f0fcf9806697ef2754e83b24815a2c97af363dtree
parentb1332e98c441b40300670f55a4303bf69cd8b226commit | 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.