-- Name: validatable_datasources(anyelement); Type: FUNCTION; Schema: public_validations; Owner: -

--

CREATE FUNCTION validatable_datasources(schema_anchor anyelement DEFAULT NULL::schema_anchor) RETURNS SETOF text

    LANGUAGE plpgsql

    AS $$

/* must use LANGUAGE plpgsql because LANGUAGE sql does not support runtime

changes of search_path (schema elements are bound at inline time rather than

runtime) */

/* function option search_path is needed to limit the effects of

`SET LOCAL search_path` (mk_set_search_path()) to the current function */

BEGIN

	EXECUTE util.mk_use_own_schema(schema_anchor);

	RETURN QUERY

		SELECT DISTINCT util.schema(view) FROM validation_views() view;

END;

$$;

--