yeti--1.3.7.sql

---
--- import functions
---
CREATE OR REPLACE FUNCTION replace_rand(TEXT)
RETURNS TEXT
AS '$libdir/yeti_pg_ext', 'replace_rand'
LANGUAGE C VOLATILE STRICT;

CREATE OR REPLACE FUNCTION regexp_replace_rand(text_in TEXT, regexp_rule TEXT, regexp_result TEXT, regexp_opt TEXT, keep_empty BOOL = FALSE)
RETURNS TEXT
AS '$libdir/yeti_pg_ext', 'regexp_replace_rand'
LANGUAGE C VOLATILE;

CREATE OR REPLACE FUNCTION regexp_replace_rand(text_in TEXT, regexp_rule TEXT, regexp_result TEXT, keep_empty BOOL = FALSE)
RETURNS TEXT
AS '$libdir/yeti_pg_ext', 'regexp_replace_rand_noopt'
LANGUAGE C VOLATILE;

CREATE OR REPLACE FUNCTION regexp_replace_rand(text_in TEXT[], regexp_rule TEXT, regexp_result TEXT, keep_empty BOOL = FALSE)
RETURNS TEXT[]
AS '$libdir/yeti_pg_ext', 'regexp_replace_rand_array_noopt'
LANGUAGE C VOLATILE;

CREATE OR REPLACE FUNCTION lnp_resolve_cnam(database_id INTEGER, data JSON)
RETURNS JSON
AS '$libdir/yeti_pg_ext', 'lnp_resolve_cnam'
LANGUAGE C IMMUTABLE STRICT;

CREATE TYPE lnp_result AS (lrn TEXT, tag TEXT);
CREATE OR REPLACE FUNCTION lnp_resolve_tagged(database_id INTEGER, local_number TEXT)
RETURNS lnp_result
AS '$libdir/yeti_pg_ext', 'lnp_resolve_tagged'
LANGUAGE C IMMUTABLE STRICT;

CREATE OR REPLACE FUNCTION lnp_endpoints_set(endpoints TEXT[])
RETURNS VOID
AS '$libdir/yeti_pg_ext', 'lnp_endpoints_set'
LANGUAGE C IMMUTABLE STRICT;

CREATE TYPE endpoints AS (id integer, uri TEXT);
CREATE OR REPLACE FUNCTION lnp_endpoints_show()
RETURNS SETOF endpoints
AS '$libdir/yeti_pg_ext', 'lnp_endpoints_show'
LANGUAGE C IMMUTABLE STRICT;

CREATE OR REPLACE FUNCTION lnp_set_timeout(timeout_msec INTEGER)
RETURNS VOID
AS '$libdir/yeti_pg_ext', 'lnp_set_timeout'
LANGUAGE C IMMUTABLE STRICT;

CREATE OR REPLACE FUNCTION rank_dns_srv(weight INTEGER)
RETURNS INTEGER
AS '$libdir/yeti_pg_ext', 'rank_dns_srv'
LANGUAGE C WINDOW;

CREATE OR REPLACE FUNCTION tag_action(op int, a int [], b int[])
RETURNS int[]
AS '$libdir/yeti_pg_ext', 'tag_action'
LANGUAGE C IMMUTABLE;

CREATE OR REPLACE FUNCTION tag_compare(a int [], b int[], match_mode smallint = 0)
RETURNS int
AS '$libdir/yeti_pg_ext', 'tag_compare'
LANGUAGE C IMMUTABLE;

CREATE OR REPLACE FUNCTION tbf_rate_check(namespace_id INTEGER, bucket_id BIGINT, rate REAL)
RETURNS BOOLEAN
AS '$libdir/yeti_pg_ext', 'tbf_rate_check'
LANGUAGE C VOLATILE;

CREATE TYPE lnp_result_with_error AS (lrn TEXT, tag TEXT, error TEXT);
CREATE OR REPLACE FUNCTION lnp_resolve_tagged_with_error(database_id INTEGER, local_number TEXT)
RETURNS lnp_result_with_error
AS '$libdir/yeti_pg_ext', 'lnp_resolve_tagged_with_error'
LANGUAGE C IMMUTABLE STRICT;