-- Name: _taxonlabel_set_matched_label_id(int(11), int(11), double precision); Type: FUNCTION; Schema: public; Owner: -

--

--

-- Name: _taxonlabel_set_matched_label_id(integer, integer, double precision); Type: FUNCTION; Schema: public; Owner: -

--

CREATE FUNCTION _taxonlabel_set_matched_label_id(taxonlabel_id integer, matched_label_id integer, matched_label_fit_fraction double precision DEFAULT NULL::double precision) RETURNS integer

    LANGUAGE plpgsql

    AS $$

BEGIN

    -- Use EXECUTE to avoid caching query plan

    EXECUTE '

    UPDATE taxonlabel SET

      matched_label_id = '||quote_nullable(matched_label_id)||'

    , matched_label_fit_fraction = '

        ||quote_nullable(matched_label_fit_fraction)||'

    WHERE taxonlabel_id = '||quote_nullable(taxonlabel_id)||'

    ';

    RETURN taxonlabel_id;

END;

$$;

--