Project

General

Profile

« Previous | Next » 

Revision 13528

inputs/.TNRS/schema.sql: added taxon_scrub_modify()

View differences:

trunk/inputs/.TNRS/schema.sql
131 131

  
132 132

  
133 133
--
134
-- Name: taxon_scrub_modify(text); Type: FUNCTION; Schema: TNRS; Owner: -
135
--
136

  
137
CREATE FUNCTION taxon_scrub_modify(view_query text) RETURNS void
138
    LANGUAGE sql
139
    AS $_$
140
SELECT util.recreate_view('"TNRS".taxon_scrub', $1);
141
$_$;
142

  
143

  
144
--
145
-- Name: FUNCTION taxon_scrub_modify(view_query text); Type: COMMENT; Schema: TNRS; Owner: -
146
--
147

  
148
COMMENT ON FUNCTION taxon_scrub_modify(view_query text) IS '
149
usage:
150
SELECT "TNRS".taxon_scrub_modify($$
151
 SELECT *
152
   FROM "TNRS"."ValidMatchedTaxon"
153
   LEFT JOIN "TNRS"."taxon_scrub.scrubbed_unique_taxon_name.*" USING (scrubbed_unique_taxon_name);
154
$$);
155

  
156
idempotent
157
';
158

  
159

  
160
--
134 161
-- Name: tnrs_populate_fields(); Type: FUNCTION; Schema: TNRS; Owner: -
135 162
--
136 163

  

Also available in: Unified diff