X-Git-Url: https://git.8kb.co.uk/?p=postgresql%2Fpg_jsonb_opx;a=blobdiff_plain;f=jsonb_opx--1.0--1.1.sql;fp=jsonb_opx--1.0--1.1.sql;h=805575c1902576e3fa70c3a1337311cfab6e82e5;hp=a1eb5ad705b6bbf96ff982246cf3da089fec677d;hb=e22272adc71704855818856546b134733d6334a1;hpb=c121fab7a779e85ecb31c42ba4788630370a2c75 diff --git a/jsonb_opx--1.0--1.1.sql b/jsonb_opx--1.0--1.1.sql index a1eb5ad..805575c 100755 --- a/jsonb_opx--1.0--1.1.sql +++ b/jsonb_opx--1.0--1.1.sql @@ -19,3 +19,11 @@ RETURNS jsonb AS 'MODULE_PATHNAME', 'jsonb_replace_path' LANGUAGE C IMMUTABLE STRICT; COMMENT ON FUNCTION jsonb_replace_path(jsonb, text[], jsonb) IS 'follow path of keys in order supplied in array and replace end-point key value pair with supplied jsonb'; + +-- + +CREATE OR REPLACE FUNCTION jsonb_append_path(jsonb, text[], jsonb) +RETURNS jsonb + AS 'MODULE_PATHNAME', 'jsonb_append_path' +LANGUAGE C IMMUTABLE STRICT; +COMMENT ON FUNCTION jsonb_append_path(jsonb, text[], jsonb) IS 'follow path of keys in order supplied in array and append to end-point key value pair with supplied jsonb';