Rename jsonb_replace to jsonb_set and allow it to add new values The function is given a fourth parameter, which defaults to true. When this parameter is true, if the last element of the path is missing in the original json, jsonb_set creates it in the result and assigns it the new value. If it is false then the function does nothing unless all elements of the path are present, including the last.
Based on some original code from Dmitry Dolgov, heavily modified by me. Catalog version bumped. Branch ------ master Details ------- http://git.postgresql.org/pg/commitdiff/37def4224505f3a23a5eef000f0d05daea59c5b5 Modified Files -------------- doc/src/sgml/func.sgml | 51 +++++++++-- src/backend/catalog/system_views.sql | 8 ++ src/backend/utils/adt/jsonfuncs.c | 151 +++++++++++++++++++++++---------- src/include/catalog/catversion.h | 2 +- src/include/catalog/pg_proc.h | 4 +- src/include/utils/jsonb.h | 2 +- src/test/regress/expected/jsonb.out | 124 +++++++++++++++++++++------ src/test/regress/expected/jsonb_1.out | 124 +++++++++++++++++++++------ src/test/regress/sql/jsonb.sql | 46 +++++++--- 9 files changed, 385 insertions(+), 127 deletions(-) -- Sent via pgsql-committers mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-committers
