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

--

--

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

--

--

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

--

--

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

--

--

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

--

CREATE FUNCTION placepath_canon_placepath_id_self_ref() RETURNS trigger

    LANGUAGE plpgsql

    AS $$

BEGIN

    IF new.canon_placepath_id = 0 THEN -- make self-reference

        new.placepath_id = nextval('placepath_placepath_id_seq'::regclass);

        new.canon_placepath_id = new.placepath_id;

    END IF;

    RETURN new;

END;

$$;

--

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

--

CREATE FUNCTION taxonpath_canon_taxonpath_id_self_ref() RETURNS trigger

    LANGUAGE plpgsql

    AS $$

BEGIN

    IF new.canon_taxonpath_id = 0 THEN -- make self-reference

        new.taxonpath_id = nextval('taxonpath_taxonpath_id_seq'::regclass);

        new.canon_taxonpath_id = new.taxonpath_id;

    END IF;

    RETURN new;

END;

$$;

--

COMMENT ON COLUMN placepath.canon_placepath_id IS 'The placepath containing the scrubbed name of this verbatim place path. placepaths should be linked only one level deep, with verbatim place paths pointing to scrubbed names.

A scrubbed name should point to itself in this field. This is automatically created by setting this field to the special value 0.';

COMMENT ON COLUMN taxonpath.canon_taxonpath_id IS 'The taxonpath containing the scrubbed name of this verbatim taxonomic name. taxonpaths should be linked only one level deep, with verbatim taxonomic names pointing to scrubbed names.

A scrubbed name should point to itself in this field. This is automatically created by setting this field to the special value 0.';

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

--

CREATE TRIGGER placepath_canon_placepath_id_self_ref BEFORE INSERT OR UPDATE ON placepath FOR EACH ROW EXECUTE PROCEDURE placepath_canon_placepath_id_self_ref();

--

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

--

CREATE TRIGGER taxonpath_canon_taxonpath_id_self_ref BEFORE INSERT OR UPDATE ON taxonpath FOR EACH ROW EXECUTE PROCEDURE taxonpath_canon_taxonpath_id_self_ref();

--