-- Name: rm_query_group(varchar(255), anyelement); Type: FUNCTION; Schema: public_validations; Owner: -

--

--

-- Name: FUNCTION rm_query_group(group_ varchar(255), schema_anchor anyelement); Type: COMMENT; Schema: public_validations; Owner: -

--

--

-- Name: rm_query_group(text, anyelement); Type: FUNCTION; Schema: public_validations; Owner: -

--

CREATE FUNCTION rm_query_group(group_ text, schema_anchor anyelement DEFAULT NULL::schema_anchor) RETURNS void

    LANGUAGE sql

    AS $_$

SELECT util.drop_relations_like('^_'||util.regexp_quote($1)||'_', $2,

force := true/*needed because some query-view-relations depend on others*/)

$_$;

--

-- Name: FUNCTION rm_query_group(group_ text, schema_anchor anyelement); Type: COMMENT; Schema: public_validations; Owner: -

--

COMMENT ON FUNCTION rm_query_group(group_ text, schema_anchor anyelement) IS '

removes all validations queries with a particular group prefix.

note that this will cascadingly drop all input/ouptut tables for those queries''

results, as well (as these inherit from type tables in this schema).

usage:

SELECT public_validations.rm_query_group(''plots'');

idempotent

schema_anchor: identifies which schema to use. should be left as the default value.

';

--