--

CREATE FUNCTION _lowercase(value text) RETURNS text

    AS $_$

SELECT lower($1)

$_$;

--

CREATE FUNCTION _not(value boolean) RETURNS boolean

    AS $_$

SELECT NOT $1

$_$;

--

CREATE FUNCTION _split(value text DEFAULT NULL::text, separator text DEFAULT '; '::text) RETURNS SETOF text

    AS $_$

SELECT regexp_split_to_table($1, $2)

$_$;

--

CREATE FUNCTION contains(search_for text, in_str text) RETURNS boolean

    AS $_$

SELECT position($1 in $2) > 0 /*1-based offset*/

$_$;

--

CREATE FUNCTION ensure_prefix(prefix text, str text) RETURNS text

    AS $_$

SELECT (CASE WHEN util.has_prefix($1, $2) THEN $2 ELSE $1||$2 END)

$_$;

--

CREATE FUNCTION has_prefix(prefix text, str text) RETURNS boolean

    AS $_$

SELECT substring($2 for length($1)) = $1

$_$;