1 \echo Use "CREATE EXTENSION jsonb_opx" to load this file. \quit
3 -- CREATE OR REPLACE FUNCTION jsonb_delete (jsonb, text)
5 -- AS 'SELECT jsonb_delete($1, ARRAY[$2]);'
6 -- LANGUAGE SQL IMMUTABLE STRICT;
7 -- COMMENT ON FUNCTION jsonb_delete(jsonb, text) IS 'delete key in second argument from first argument';
9 CREATE OR REPLACE FUNCTION jsonb_delete (jsonb, text)
11 AS 'MODULE_PATHNAME', 'jsonb_delete_key'
12 LANGUAGE C IMMUTABLE STRICT;
13 COMMENT ON FUNCTION jsonb_delete(jsonb, text) IS 'delete key or string values in second argument from first argument';
15 DROP OPERATOR IF EXISTS - (jsonb, text);
16 CREATE OPERATOR - ( PROCEDURE = jsonb_delete, LEFTARG = jsonb, RIGHTARG = text);
17 COMMENT ON OPERATOR - (jsonb, text) IS 'delete key from left operand';
21 CREATE OR REPLACE FUNCTION jsonb_delete(jsonb, numeric)
23 AS 'MODULE_PATHNAME', 'jsonb_delete_key'
24 LANGUAGE C IMMUTABLE STRICT;
25 COMMENT ON FUNCTION jsonb_delete(jsonb, numeric) IS 'delete numeric elements in second argument from first argument';
27 DROP OPERATOR IF EXISTS - (jsonb, numeric);
28 CREATE OPERATOR - ( PROCEDURE = jsonb_delete, LEFTARG = jsonb, RIGHTARG = numeric);
29 COMMENT ON OPERATOR - (jsonb, numeric) IS 'delete numeric elements from left operand';
33 CREATE OR REPLACE FUNCTION jsonb_delete(jsonb, boolean)
35 AS 'MODULE_PATHNAME', 'jsonb_delete_key'
36 LANGUAGE C IMMUTABLE STRICT;
37 COMMENT ON FUNCTION jsonb_delete(jsonb, boolean) IS 'delete boolean elements in second argument from first argument';
39 DROP OPERATOR IF EXISTS - (jsonb, boolean);
40 CREATE OPERATOR - ( PROCEDURE = jsonb_delete, LEFTARG = jsonb, RIGHTARG = boolean);
41 COMMENT ON OPERATOR - (jsonb, boolean) IS 'delete boolean elements from left operand';
45 CREATE OR REPLACE FUNCTION jsonb_delete(jsonb, text[])
47 AS 'MODULE_PATHNAME', 'jsonb_delete_keys'
48 LANGUAGE C IMMUTABLE STRICT;
49 COMMENT ON FUNCTION jsonb_delete(jsonb, text[]) IS 'delete keys or string values in second argument from first argument';
51 DROP OPERATOR IF EXISTS - (jsonb, text[]);
52 CREATE OPERATOR - ( PROCEDURE = jsonb_delete, LEFTARG = jsonb, RIGHTARG = text[]);
53 COMMENT ON OPERATOR - (jsonb, text[]) IS 'delete keys from left operand';
57 CREATE OR REPLACE FUNCTION jsonb_delete(jsonb, numeric[])
59 AS 'MODULE_PATHNAME', 'jsonb_delete_keys'
60 LANGUAGE C IMMUTABLE STRICT;
61 COMMENT ON FUNCTION jsonb_delete(jsonb, numeric[]) IS 'delete numeric elements in second argument from first argument';
63 DROP OPERATOR IF EXISTS - (jsonb, numeric[]);
64 CREATE OPERATOR - ( PROCEDURE = jsonb_delete, LEFTARG = jsonb, RIGHTARG = numeric[]);
65 COMMENT ON OPERATOR - (jsonb, numeric[]) IS 'delete numeric elements from left operand';
69 CREATE OR REPLACE FUNCTION jsonb_delete(jsonb, boolean[])
71 AS 'MODULE_PATHNAME', 'jsonb_delete_keys'
72 LANGUAGE C IMMUTABLE STRICT;
73 COMMENT ON FUNCTION jsonb_delete(jsonb, boolean[]) IS 'delete boolean elements in second argument from first argument';
75 DROP OPERATOR IF EXISTS - (jsonb, boolean[]);
76 CREATE OPERATOR - ( PROCEDURE = jsonb_delete, LEFTARG = jsonb, RIGHTARG = boolean[]);
77 COMMENT ON OPERATOR - (jsonb, boolean[]) IS 'delete boolean elements from left operand';
81 CREATE OR REPLACE FUNCTION jsonb_delete(jsonb, jsonb)
83 AS 'MODULE_PATHNAME', 'jsonb_delete_jsonb'
84 LANGUAGE C IMMUTABLE STRICT;
85 COMMENT ON FUNCTION jsonb_delete(jsonb, jsonb) IS 'delete matching pairs in second argument from first argument';
87 DROP OPERATOR IF EXISTS - (jsonb, jsonb);
88 CREATE OPERATOR - ( PROCEDURE = jsonb_delete, LEFTARG = jsonb, RIGHTARG = jsonb);
89 COMMENT ON OPERATOR - (jsonb, jsonb) IS 'delete matching pairs from left operand';
93 CREATE OR REPLACE FUNCTION jsonb_concat(jsonb, jsonb)
95 AS 'MODULE_PATHNAME', 'jsonb_concat_jsonb'
96 LANGUAGE C IMMUTABLE STRICT;
97 COMMENT ON FUNCTION jsonb_concat(jsonb, jsonb) IS 'concatenate first and second jsonb arguments';
99 DROP OPERATOR IF EXISTS || (jsonb, jsonb);
100 CREATE OPERATOR || ( PROCEDURE = jsonb_concat, LEFTARG = jsonb, RIGHTARG = jsonb);
101 COMMENT ON OPERATOR || (jsonb, jsonb) IS 'concatenate jsonb types';
105 CREATE OR REPLACE FUNCTION jsonb_replace(jsonb, jsonb)
107 AS 'MODULE_PATHNAME', 'jsonb_replace_jsonb'
108 LANGUAGE C IMMUTABLE STRICT;
109 COMMENT ON FUNCTION jsonb_replace(jsonb, jsonb) IS 'replace occurrences of second jsonb argument in first';
111 DROP OPERATOR IF EXISTS #= (jsonb, jsonb);
112 CREATE OPERATOR #= ( PROCEDURE = jsonb_replace, LEFTARG = jsonb, RIGHTARG = jsonb);
113 COMMENT ON OPERATOR #= (jsonb, jsonb) IS 'replace values for matching keys in jsonb types';