\echo Use "CREATE EXTENSION re2" to load this file. \quit CREATE FUNCTION re2match(text, text) RETURNS boolean AS 'MODULE_PATHNAME', 'pgre2_match' LANGUAGE C IMMUTABLE STRICT PARALLEL SAFE; CREATE FUNCTION re2extract(text, text) RETURNS text AS 'MODULE_PATHNAME', 'pgre2_extract' LANGUAGE C IMMUTABLE STRICT PARALLEL SAFE; CREATE FUNCTION re2extractall(text, text) RETURNS text[] AS 'MODULE_PATHNAME', 'pgre2_extractall' LANGUAGE C IMMUTABLE STRICT PARALLEL SAFE; CREATE FUNCTION re2regexpextract(text, text, int DEFAULT 1) RETURNS text AS 'MODULE_PATHNAME', 'pgre2_regexpextract' LANGUAGE C IMMUTABLE STRICT PARALLEL SAFE; CREATE FUNCTION re2extractgroups(text, text) RETURNS text[] AS 'MODULE_PATHNAME', 'pgre2_extractgroups' LANGUAGE C IMMUTABLE STRICT PARALLEL SAFE; CREATE FUNCTION re2replaceregexpone(text, text, text) RETURNS text AS 'MODULE_PATHNAME', 'pgre2_replaceregexpone' LANGUAGE C IMMUTABLE STRICT PARALLEL SAFE; CREATE FUNCTION re2replaceregexpall(text, text, text) RETURNS text AS 'MODULE_PATHNAME', 'pgre2_replaceregexpall' LANGUAGE C IMMUTABLE STRICT PARALLEL SAFE; CREATE FUNCTION re2countmatches(text, text) RETURNS integer AS 'MODULE_PATHNAME', 'pgre2_countmatches' LANGUAGE C IMMUTABLE STRICT PARALLEL SAFE; CREATE FUNCTION re2countmatchescaseinsensitive(text, text) RETURNS integer AS 'MODULE_PATHNAME', 'pgre2_countmatchescaseinsensitive' LANGUAGE C IMMUTABLE STRICT PARALLEL SAFE; CREATE FUNCTION re2multimatchany(text, VARIADIC text[]) RETURNS boolean AS 'MODULE_PATHNAME', 'pgre2_multimatchany' LANGUAGE C IMMUTABLE STRICT PARALLEL SAFE; CREATE FUNCTION re2multimatchanyindex(text, VARIADIC text[]) RETURNS integer AS 'MODULE_PATHNAME', 'pgre2_multimatchanyindex' LANGUAGE C IMMUTABLE STRICT PARALLEL SAFE; CREATE FUNCTION re2multimatchallindices(text, VARIADIC text[]) RETURNS integer[] AS 'MODULE_PATHNAME', 'pgre2_multimatchallindices' LANGUAGE C IMMUTABLE STRICT PARALLEL SAFE; -- bytea overloads (haystack can contain \0 bytes) CREATE FUNCTION re2match(bytea, text) RETURNS boolean AS 'MODULE_PATHNAME', 'pgre2_match_bytea' LANGUAGE C IMMUTABLE STRICT PARALLEL SAFE; CREATE FUNCTION re2extract(bytea, text) RETURNS bytea AS 'MODULE_PATHNAME', 'pgre2_extract_bytea' LANGUAGE C IMMUTABLE STRICT PARALLEL SAFE; CREATE FUNCTION re2extractall(bytea, text) RETURNS bytea[] AS 'MODULE_PATHNAME', 'pgre2_extractall_bytea' LANGUAGE C IMMUTABLE STRICT PARALLEL SAFE; CREATE FUNCTION re2regexpextract(bytea, text, int DEFAULT 1) RETURNS bytea AS 'MODULE_PATHNAME', 'pgre2_regexpextract_bytea' LANGUAGE C IMMUTABLE STRICT PARALLEL SAFE; CREATE FUNCTION re2extractgroups(bytea, text) RETURNS bytea[] AS 'MODULE_PATHNAME', 'pgre2_extractgroups_bytea' LANGUAGE C IMMUTABLE STRICT PARALLEL SAFE; CREATE FUNCTION re2replaceregexpone(bytea, text, text) RETURNS bytea AS 'MODULE_PATHNAME', 'pgre2_replaceregexpone_bytea' LANGUAGE C IMMUTABLE STRICT PARALLEL SAFE; CREATE FUNCTION re2replaceregexpall(bytea, text, text) RETURNS bytea AS 'MODULE_PATHNAME', 'pgre2_replaceregexpall_bytea' LANGUAGE C IMMUTABLE STRICT PARALLEL SAFE; CREATE FUNCTION re2countmatches(bytea, text) RETURNS integer AS 'MODULE_PATHNAME', 'pgre2_countmatches_bytea' LANGUAGE C IMMUTABLE STRICT PARALLEL SAFE; CREATE FUNCTION re2countmatchescaseinsensitive(bytea, text) RETURNS integer AS 'MODULE_PATHNAME', 'pgre2_countmatchescaseinsensitive_bytea' LANGUAGE C IMMUTABLE STRICT PARALLEL SAFE; CREATE FUNCTION re2multimatchany(bytea, VARIADIC text[]) RETURNS boolean AS 'MODULE_PATHNAME', 'pgre2_multimatchany_bytea' LANGUAGE C IMMUTABLE STRICT PARALLEL SAFE; CREATE FUNCTION re2multimatchanyindex(bytea, VARIADIC text[]) RETURNS integer AS 'MODULE_PATHNAME', 'pgre2_multimatchanyindex_bytea' LANGUAGE C IMMUTABLE STRICT PARALLEL SAFE; CREATE FUNCTION re2multimatchallindices(bytea, VARIADIC text[]) RETURNS integer[] AS 'MODULE_PATHNAME', 'pgre2_multimatchallindices_bytea' LANGUAGE C IMMUTABLE STRICT PARALLEL SAFE;