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

Поиск
Список
Период
Сортировка
От Andrew Dunstan
Тема pgsql: Add several generator functions for jsonb that exist for json.
Дата
Msg-id E1XzX1w-0001RR-9F@gemulon.postgresql.org
обсуждение исходный текст
Список 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(-)


В списке pgsql-committers по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: pgsql: Revert misguided change to postgres_fdw FOR UPDATE/SHARE code.
Следующее
От: Tom Lane
Дата:
Сообщение: pgsql: Avoid instability in output of new REINDEX SCHEMA test.