-- Name: source_by_shortname(varchar(255), anyelement); Type: FUNCTION; Schema: public; Owner: -

-- Name: source_by_shortname(text, anyelement); Type: FUNCTION; Schema: public; Owner: -

CREATE FUNCTION source_by_shortname(shortname text, schema_anchor anyelement DEFAULT NULL::schema_anchor) RETURNS integer

    LANGUAGE plpgsql STABLE STRICT

    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) */

DECLARE

	source_id integer;

	shortname_ text = shortname;

BEGIN

	PERFORM set_config('search_path', util.schema_esc(schema_anchor), true);

	SELECT source_id INTO source_id

	FROM source WHERE shortname = shortname_ LIMIT 1

	;

	RETURN source_id;

END;

$$;