-- Name: tnrs__match_num__fill(); Type: FUNCTION; Schema: TNRS; Owner: -

--

CREATE FUNCTION tnrs__match_num__fill() RETURNS trigger

    LANGUAGE plpgsql

    AS $$

BEGIN

	new.match_num = "TNRS".tnrs__match_num__next();

	RETURN new;

END;

$$;

--

-- Name: tnrs__match_num__fill; Type: TRIGGER; Schema: TNRS; Owner: -

--

CREATE TRIGGER tnrs__match_num__fill BEFORE INSERT ON tnrs FOR EACH ROW EXECUTE PROCEDURE tnrs__match_num__fill();

--

-- Name: tnrs__match_num__fill(); Type: FUNCTION; Schema: TNRS; Owner: -

--

--

-- Name: tnrs__match_num__fill; Type: TRIGGER; Schema: TNRS; Owner: -

--

--

-- Name: tnrs__match_num__fill(); Type: FUNCTION; Schema: TNRS; Owner: -

--

CREATE FUNCTION tnrs__match_num__fill() RETURNS trigger

    LANGUAGE plpgsql

    AS $$

BEGIN

	new.match_num = "TNRS".tnrs__match_num__next();

	RETURN new;

END;

$$;

--

-- Name: tnrs__match_num__fill; Type: TRIGGER; Schema: TNRS; Owner: -

--

CREATE TRIGGER tnrs__match_num__fill BEFORE INSERT ON tnrs FOR EACH ROW EXECUTE PROCEDURE tnrs__match_num__fill();

--