Thread: pgsql: Add jsonb_insert
Add jsonb_insert It inserts a new value into an jsonb array at arbitrary position or a new key to jsonb object. Author: Dmitry Dolgov Reviewers: Petr Jelinek, Vitaly Burovoy, Andrew Dunstan Branch ------ master Details ------- http://git.postgresql.org/pg/commitdiff/0b62fd036e1ac48a8432bb9664b21e1f036c1b08 Modified Files -------------- doc/src/sgml/func.sgml | 45 ++++++++++-- src/backend/catalog/system_views.sql | 8 +++ src/backend/utils/adt/jsonfuncs.c | 134 ++++++++++++++++++++++++++++------- src/include/catalog/catversion.h | 2 +- src/include/catalog/pg_proc.h | 2 + src/include/utils/jsonb.h | 3 + src/test/regress/expected/jsonb.out | 129 +++++++++++++++++++++++++++++++++ src/test/regress/sql/jsonb.sql | 30 ++++++++ 8 files changed, 324 insertions(+), 29 deletions(-)