]> granicus.if.org Git - postgresql/commit
Add several generator functions for jsonb that exist for json.
authorAndrew Dunstan <andrew@dunslane.net>
Fri, 12 Dec 2014 20:31:14 +0000 (15:31 -0500)
committerAndrew Dunstan <andrew@dunslane.net>
Fri, 12 Dec 2014 20:31:14 +0000 (15:31 -0500)
commit7e354ab9fe9e7c3b0a7a40f226c76bd5cf6438d0
treed306f564a7ec8a3fc0a657c93671f36a63b0dce2
parent8ec8760fc87ecde0516e511f1c55aec627b01ea7
Add several generator functions for jsonb that exist for json.

The functions are:
    to_jsonb()
    jsonb_object()
    jsonb_build_object()
    jsonb_build_array()
    jsonb_agg()
    jsonb_object_agg()

Also along the way some better logic is implemented in
json_categorize_type() to match that in the newly implemented
jsonb_categorize_type().

Andrew Dunstan, reviewed by Pavel Stehule and Alvaro Herrera.
doc/src/sgml/func.sgml
src/backend/utils/adt/json.c
src/backend/utils/adt/jsonb.c
src/backend/utils/adt/jsonb_util.c
src/include/catalog/catversion.h
src/include/catalog/pg_aggregate.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