1 -- CREATE OR REPLACE FUNCTION public.jsonb_delete (jsonb, text)
3 -- AS 'SELECT jsonb_delete($1, ARRAY[$2]);'
4 -- LANGUAGE SQL IMMUTABLE STRICT;
5 -- COMMENT ON FUNCTION public.jsonb_delete(jsonb, text) IS 'delete key in second argument from first argument';
7 CREATE OR REPLACE FUNCTION public.jsonb_delete (jsonb, text)
9 AS 'MODULE_PATHNAME', 'jsonb_delete_key'
10 LANGUAGE C IMMUTABLE STRICT;
11 COMMENT ON FUNCTION public.jsonb_delete(jsonb, text) IS 'delete key in second argument from first argument';
13 -- DROP OPERATOR - (jsonb, text);
14 CREATE OPERATOR - ( PROCEDURE = public.jsonb_delete, LEFTARG = jsonb, RIGHTARG = text);
15 COMMENT ON OPERATOR - (jsonb, text) IS 'delete key from left operand';
18 CREATE OR REPLACE FUNCTION public.jsonb_delete(jsonb, text[])
20 AS 'MODULE_PATHNAME', 'jsonb_delete_keys'
21 LANGUAGE C IMMUTABLE STRICT;
22 COMMENT ON FUNCTION public.jsonb_delete(jsonb, text[]) IS 'delete keys in second argument from first argument';
24 -- DROP OPERATOR - (jsonb, text[]);
25 CREATE OPERATOR - ( PROCEDURE = public.jsonb_delete, LEFTARG = jsonb, RIGHTARG = text[]);
26 COMMENT ON OPERATOR - (jsonb, text[]) IS 'delete keys from left operand';
30 CREATE OR REPLACE FUNCTION public.jsonb_delete(jsonb, jsonb)
32 AS 'MODULE_PATHNAME', 'jsonb_delete_jsonb'
33 LANGUAGE C IMMUTABLE STRICT;
34 COMMENT ON FUNCTION public.jsonb_delete(jsonb, jsonb) IS 'delete matching pairs in second argument from first argument';
36 -- DROP OPERATOR - (jsonb, jsonb);
37 CREATE OPERATOR - ( PROCEDURE = public.jsonb_delete, LEFTARG = jsonb, RIGHTARG = jsonb);
38 COMMENT ON OPERATOR - (jsonb, jsonb) IS 'delete matching pairs from left operand';
42 CREATE OR REPLACE FUNCTION public.jsonb_concat(jsonb, jsonb)
44 AS 'MODULE_PATHNAME', 'jsonb_concat_jsonb'
45 LANGUAGE C IMMUTABLE STRICT;
46 COMMENT ON FUNCTION public.jsonb_concat(jsonb, jsonb) IS 'concatenate first and second jsonb arguments';
48 -- DROP OPERATOR || (jsonb, jsonb);
49 CREATE OPERATOR || ( PROCEDURE = public.jsonb_concat, LEFTARG = jsonb, RIGHTARG = jsonb);
50 COMMENT ON OPERATOR || (jsonb, jsonb) IS 'concatenate jsonb types';