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

--

CREATE FUNCTION taxonlabel_1_matched_label_min_fit() RETURNS trigger

    LANGUAGE plpgsql

    AS $$

BEGIN

    IF new.matched_label_id IS NOT NULL

        AND new.matched_label_fit_fraction < 0.8 THEN -- insufficient match

        new.matched_label_id = NULL;

        new.matched_label_fit_fraction = NULL;

    END IF;

    RETURN new;

END;

$$;

--

    matched_label_fit_fraction double precision,

    CONSTRAINT taxonlabel_matched_label_fit_fraction_range CHECK (((matched_label_fit_fraction >= (0)::double precision) AND (matched_label_fit_fraction <= (1)::double precision))),

-- Name: COLUMN taxonlabel.matched_label_fit_fraction; Type: COMMENT; Schema: public; Owner: -

--

COMMENT ON COLUMN taxonlabel.matched_label_fit_fraction IS 'The closeness of fit of the matched label.';

--

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

--

CREATE TRIGGER taxonlabel_1_matched_label_min_fit BEFORE INSERT OR UPDATE ON taxonlabel FOR EACH ROW EXECUTE PROCEDURE taxonlabel_1_matched_label_min_fit();

--