-- Name: sourcename_set_matched_source_id(); Type: FUNCTION; Schema: public; Owner: -

--

CREATE FUNCTION sourcename_set_matched_source_id() RETURNS trigger

    LANGUAGE plpgsql

    AS $$

BEGIN

    IF new.matched_source_id IS NULL THEN -- populate matched_source_id

        new.matched_source_id :=

            (SELECT source_id FROM source WHERE shortname = new.name);

    END IF;

    RETURN new;

END;

$$;

--

-- Name: sourcename_set_matched_source_id; Type: TRIGGER; Schema: public; Owner: -

--

CREATE TRIGGER sourcename_set_matched_source_id BEFORE INSERT OR UPDATE ON sourcename FOR EACH ROW EXECUTE PROCEDURE sourcename_set_matched_source_id();

--