Project

General

Profile

« Previous | Next » 

Revision 13533

Added by Aaron Marcuse-Kubitza about 10 years ago

inputs/.TNRS/schema.sql: taxon_scrub: added scrubbed_morphospecies_binomial, analogous to accepted_morphospecies_binomial for scrubbed_*

View differences:

schema.sql
148 148 
COMMENT ON FUNCTION taxon_scrub_modify(view_query text) IS '
149 149 
usage:
150 150 
SELECT "TNRS".taxon_scrub_modify($$
151 
 SELECT *
151 
 SELECT *, __ AS scrubbed_morphospecies_binomial
152 152 
   FROM "TNRS"."ValidMatchedTaxon"
153 153 
   LEFT JOIN "TNRS"."taxon_scrub.scrubbed_unique_taxon_name.*" USING (scrubbed_unique_taxon_name);
154 154 
$$);
......
593 593 
COMMENT ON VIEW taxon_scrub IS '
594 594 
to modify:
595 595 
SELECT "TNRS".taxon_scrub_modify($$
596 
 SELECT *
596 
 SELECT *, __ AS scrubbed_morphospecies_binomial
597 597 
   FROM "TNRS"."ValidMatchedTaxon"
598 598 
   LEFT JOIN "TNRS"."taxon_scrub.scrubbed_unique_taxon_name.*" USING (scrubbed_unique_taxon_name);
599 599 
$$);

Also available in: Unified diff