Project

General

Profile

« Previous | Next » 

Revision 13533

Added by Aaron Marcuse-Kubitza over 10 years ago

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

View differences:

trunk/inputs/.TNRS/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 
$$);
trunk/schemas/vegbien.sql
16912 16912 
COMMENT ON FUNCTION taxon_scrub_modify(view_query text) IS '
16913 16913 
usage:
16914 16914 
SELECT "TNRS".taxon_scrub_modify($$
16915 
 SELECT *
16915 
 SELECT *, __ AS scrubbed_morphospecies_binomial
16916 16916 
   FROM "TNRS"."ValidMatchedTaxon"
16917 16917 
   LEFT JOIN "TNRS"."taxon_scrub.scrubbed_unique_taxon_name.*" USING (scrubbed_unique_taxon_name);
16918 16918 
$$);
......
17399 17399 
COMMENT ON VIEW taxon_scrub IS '
17400 17400 
to modify:
17401 17401 
SELECT "TNRS".taxon_scrub_modify($$
17402 
 SELECT *
17402 
 SELECT *, __ AS scrubbed_morphospecies_binomial
17403 17403 
   FROM "TNRS"."ValidMatchedTaxon"
17404 17404 
   LEFT JOIN "TNRS"."taxon_scrub.scrubbed_unique_taxon_name.*" USING (scrubbed_unique_taxon_name);
17405 17405 
$$);

Also available in: Unified diff