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

--

--

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

--

--

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

--

CREATE FUNCTION taxonconcept_2_propagate_accepted_concept_id() RETURNS trigger

    LANGUAGE plpgsql

    AS $$

BEGIN

    IF new.matched_concept_id IS NOT NULL THEN

        IF new.matched_concept_id = new.taxonconcept_id THEN -- self-reference

            new.accepted_concept_id = new.taxonconcept_id;-- make self-reference

        ELSE -- propagate from matched concept

            new.accepted_concept_id = (

                SELECT accepted_concept_id

                FROM taxonconcept

                WHERE taxonconcept_id = new.matched_concept_id

            );

        END IF;

    END IF;

    RETURN new;

END;

$$;

--

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

--

CREATE TRIGGER taxonconcept_2_propagate_accepted_concept_id BEFORE INSERT OR UPDATE ON taxonconcept FOR EACH ROW EXECUTE PROCEDURE taxonconcept_2_propagate_accepted_concept_id();

--