pgsql: Additional functions and operators for jsonb
От | Andrew Dunstan |
---|---|
Тема | pgsql: Additional functions and operators for jsonb |
Дата | |
Msg-id | E1YsGHP-0006De-1z@gemulon.postgresql.org обсуждение исходный текст |
Ответы |
Re: pgsql: Additional functions and operators for jsonb
Re: pgsql: Additional functions and operators for jsonb Re: pgsql: Additional functions and operators for jsonb |
Список | pgsql-committers |
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. Branch ------ master Details ------- http://git.postgresql.org/pg/commitdiff/c6947010ceb42143d9f047c65c1eac2b38928ab7 Modified Files -------------- doc/src/sgml/func.sgml | 62 +++ src/backend/utils/adt/jsonb.c | 81 +++- src/backend/utils/adt/jsonfuncs.c | 717 +++++++++++++++++++++++++++++++++ src/include/catalog/pg_operator.h | 8 + src/include/catalog/pg_proc.h | 9 +- src/include/utils/jsonb.h | 19 +- src/test/regress/expected/jsonb.out | 424 ++++++++++++++++++- src/test/regress/expected/jsonb_1.out | 424 ++++++++++++++++++- src/test/regress/sql/jsonb.sql | 85 +++- 9 files changed, 1813 insertions(+), 16 deletions(-)
В списке pgsql-committers по дате отправления: