-- Name: mk_set_search_path(text[]); Type: FUNCTION; Schema: util; Owner: -

--

CREATE FUNCTION mk_set_search_path(VARIADIC schemas text[]) RETURNS text

    LANGUAGE sql IMMUTABLE

    AS $_$

SELECT util.mk_set_search_path(util.mk_search_path(VARIADIC $1))

$_$;

--

-- Name: FUNCTION mk_set_search_path(VARIADIC schemas text[]); Type: COMMENT; Schema: util; Owner: -

--

COMMENT ON FUNCTION mk_set_search_path(VARIADIC schemas text[]) IS '

usage:

for *1* schema arg:

SELECT util.mk_set_search_path(''schema'', NULL) AS search_path;

	-- 2 params are needed to use the correct variant of mk_set_search_path()

auto-appends util to the search_path to enable use of util operators

';

--