pgsql: Add several generator functions for jsonb that exist for json.

From: Andrew Dunstan <andrew(at)dunslane(dot)net>
To: pgsql-committers(at)postgresql(dot)org
Subject: pgsql: Add several generator functions for jsonb that exist for json.
Date: 2014-12-12 20:41:40
Message-ID: E1XzX1w-0001RR-9F@gemulon.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-committers

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.

Branch
------
master

Details
-------
http://git.postgresql.org/pg/commitdiff/7e354ab9fe9e7c3b0a7a40f226c76bd5cf6438d0

Modified Files
--------------
doc/src/sgml/func.sgml | 97 ++-
src/backend/utils/adt/json.c | 44 +-
src/backend/utils/adt/jsonb.c | 1396 +++++++++++++++++++++++++++++++++
src/backend/utils/adt/jsonb_util.c | 2 +-
src/include/catalog/catversion.h | 2 +-
src/include/catalog/pg_aggregate.h | 4 +
src/include/catalog/pg_proc.h | 26 +
src/include/utils/jsonb.h | 16 +
src/test/regress/expected/jsonb.out | 173 ++++
src/test/regress/expected/jsonb_1.out | 173 ++++
src/test/regress/sql/jsonb.sql | 115 +++
11 files changed, 2003 insertions(+), 45 deletions(-)

Browse pgsql-committers by date

  From Date Subject
Next Message Tom Lane 2014-12-12 20:49:20 pgsql: Avoid instability in output of new REINDEX SCHEMA test.
Previous Message Tom Lane 2014-12-12 17:42:10 pgsql: Revert misguided change to postgres_fdw FOR UPDATE/SHARE code.