-- Name: taxon_scrub_modify(varchar(255)); Type: FUNCTION; Schema: TNRS; Owner: -

--

--

-- Name: FUNCTION taxon_scrub_modify(view_query varchar(255)); Type: COMMENT; Schema: TNRS; Owner: -

--

--

-- Name: taxon_scrub_modify(text); Type: FUNCTION; Schema: TNRS; Owner: -

--

CREATE FUNCTION taxon_scrub_modify(view_query text) RETURNS void

    LANGUAGE sql

    AS $_$

SELECT util.recreate_view('"TNRS".taxon_scrub', $1);

$_$;

--

-- Name: FUNCTION taxon_scrub_modify(view_query text); Type: COMMENT; Schema: TNRS; Owner: -

--

COMMENT ON FUNCTION taxon_scrub_modify(view_query text) IS '

usage:

SELECT "TNRS".taxon_scrub_modify($$

 SELECT *

   FROM "TNRS"."ValidMatchedTaxon"

   LEFT JOIN "TNRS"."taxon_scrub.scrubbed_unique_taxon_name.*" USING (scrubbed_unique_taxon_name);

$$);

idempotent

';

--