-- Name: delete_scrubbed_taxondeterminations(text); Type: FUNCTION; Schema: public; Owner: -

--

CREATE FUNCTION delete_scrubbed_taxondeterminations(datasource text) RETURNS void

    LANGUAGE sql

    AS $_$

DELETE FROM taxondetermination

USING taxonoccurrence

WHERE

    taxonoccurrence.source_id = source_by_shortname($1)

AND taxondetermination.taxonoccurrence_id = taxonoccurrence.taxonoccurrence_id

AND taxondetermination.source_id = source_by_shortname('TNRS')

$_$;

--