jsonbx--1.0.sql

-- complain if script is sourced in psql, rather than via CREATE EXTENSION
\echo Use "CREATE EXTENSION jsonbx" to load this file. \quit


CREATE FUNCTION jsonb_pretty(jsonb)
RETURNS text
AS 'MODULE_PATHNAME', 'jsonb_pretty'
LANGUAGE C STRICT;

CREATE FUNCTION jsonb_concat(jsonb, jsonb)
RETURNS jsonb
AS 'MODULE_PATHNAME', 'jsonb_concat'
LANGUAGE C STRICT;

CREATE OPERATOR || (
	LEFTARG = jsonb,
	RIGHTARG = jsonb,
	PROCEDURE = jsonb_concat
);

CREATE FUNCTION jsonb_delete(jsonb,text)
RETURNS jsonb
AS 'MODULE_PATHNAME','jsonb_delete'
LANGUAGE C STRICT;

CREATE OPERATOR - (
	LEFTARG = jsonb,
	RIGHTARG = text,
	PROCEDURE = jsonb_delete
);

CREATE FUNCTION jsonb_delete(jsonb,int)
RETURNS jsonb
AS 'MODULE_PATHNAME','jsonb_delete_idx'
LANGUAGE C STRICT;

CREATE OPERATOR - (
	LEFTARG = jsonb,
	RIGHTARG = int,
	PROCEDURE = jsonb_delete
);

CREATE FUNCTION jsonb_delete(jsonb,text[])
RETURNS jsonb
AS 'MODULE_PATHNAME','jsonb_delete_path'
LANGUAGE C STRICT;

CREATE OPERATOR - (
	LEFTARG = jsonb,
	RIGHTARG = text[],
	PROCEDURE = jsonb_delete
);

CREATE FUNCTION jsonb_set(
    jsonb_in jsonb,
    path text[],
    replacement jsonb,
    create_if_missing boolean DEFAULT true
)
RETURNS jsonb
AS 'MODULE_PATHNAME','jsonb_set'
LANGUAGE C STRICT;