-- Name: remove_prefix(text, text, boolean); Type: FUNCTION; Schema: util; Owner: -

--

CREATE FUNCTION remove_prefix(prefix text, str text, require boolean DEFAULT true) RETURNS text

    LANGUAGE sql IMMUTABLE

    AS $$

SELECT CASE

WHEN substring(str from 1 for length(prefix)) = prefix THEN

	substring(str from 1+length(prefix))

WHEN NOT require THEN str

ELSE

	util.raise('data_exception', 'str does not start with prefix '

	||quote_nullable(prefix)||': '||str)::text

END

$$;

--