]> granicus.if.org Git - postgresql/commit
Additional functions and operators for jsonb
authorAndrew Dunstan <andrew@dunslane.net>
Tue, 12 May 2015 19:52:45 +0000 (15:52 -0400)
committerAndrew Dunstan <andrew@dunslane.net>
Tue, 12 May 2015 19:52:45 +0000 (15:52 -0400)
commitc6947010ceb42143d9f047c65c1eac2b38928ab7
tree038277e46347e8b1edf953f99289ac03950248ea
parentafb9249d06f47d7a6d4a89fea0c3625fe43c5a5d
Additional functions and operators for jsonb

jsonb_pretty(jsonb) produces nicely indented json output.
jsonb || jsonb concatenates two jsonb values.
jsonb - text removes a key and its associated value from the json
jsonb - int removes the designated array element
jsonb - text[] removes a key and associated value or array element at
the designated path
jsonb_replace(jsonb,text[],jsonb) replaces the array element designated
by the path or the value associated with the key designated by the path
with the given value.

Original work by Dmitry Dolgov, adapted and reworked for PostgreSQL core
by Andrew Dunstan, reviewed and tidied up by Petr Jelinek.
doc/src/sgml/func.sgml
src/backend/utils/adt/jsonb.c
src/backend/utils/adt/jsonfuncs.c
src/include/catalog/pg_operator.h
src/include/catalog/pg_proc.h
src/include/utils/jsonb.h
src/test/regress/expected/jsonb.out
src/test/regress/expected/jsonb_1.out
src/test/regress/sql/jsonb.sql