Revision 13390
Added by Aaron Marcuse-Kubitza over 10 years ago
| trunk/schemas/public_.sql | ||
|---|---|---|
| 9400 | 9400 |
-- |
| 9401 | 9401 |
|
| 9402 | 9402 |
CREATE VIEW _plots_21_tnrs_output_names AS |
| 9403 |
SELECT DISTINCT taxon_scrub."concatenatedScientificName" AS tnrs_output_name
|
|
| 9403 |
SELECT DISTINCT taxon_scrub.scrubbed_taxon_name_no_author AS tnrs_output_name
|
|
| 9404 | 9404 |
FROM (public.taxonlabel |
| 9405 | 9405 |
JOIN "TNRS".taxon_scrub ON ((taxon_scrub."concatenatedScientificName" = taxonlabel.taxonomicname))) |
| 9406 | 9406 |
WHERE ((taxonlabel.source_id = ( SELECT public.source_by_shortname(("current_schema"())::text) AS source_by_shortname)) AND (taxon_scrub."concatenatedScientificName" IS NOT NULL));
|
| trunk/schemas/vegbien.sql | ||
|---|---|---|
| 9400 | 9400 |
-- |
| 9401 | 9401 |
|
| 9402 | 9402 |
CREATE VIEW _plots_21_tnrs_output_names AS |
| 9403 |
SELECT DISTINCT taxon_scrub."concatenatedScientificName" AS tnrs_output_name
|
|
| 9403 |
SELECT DISTINCT taxon_scrub.scrubbed_taxon_name_no_author AS tnrs_output_name
|
|
| 9404 | 9404 |
FROM (public.taxonlabel |
| 9405 | 9405 |
JOIN "TNRS".taxon_scrub ON ((taxon_scrub."concatenatedScientificName" = taxonlabel.taxonomicname))) |
| 9406 | 9406 |
WHERE ((taxonlabel.source_id = ( SELECT public.source_by_shortname(("current_schema"())::text) AS source_by_shortname)) AND (taxon_scrub."concatenatedScientificName" IS NOT NULL));
|
Also available in: Unified diff
bugfix: schemas/public_.sql: _plots_21_tnrs_output_names: need to use TNRS output rather than input name