Revision 13634
Added by Aaron Marcuse-Kubitza over 10 years ago
| vegbien.sql | ||
|---|---|---|
| 8840 | 8840 |
SELECT DISTINCT taxonlabel.taxonomicname |
| 8841 | 8841 |
FROM (taxonlabel |
| 8842 | 8842 |
LEFT JOIN "TNRS"."MatchedTaxon" ON (("MatchedTaxon"."concatenatedScientificName" = taxonlabel.taxonomicname)))
|
| 8843 |
WHERE ((taxonlabel.taxonomicname IS NOT NULL) AND ("MatchedTaxon"."concatenatedScientificName" IS NULL));
|
|
| 8843 |
WHERE (((taxonlabel.taxonomicname IS NOT NULL) AND ("MatchedTaxon"."concatenatedScientificName" IS NULL)) AND "TNRS".taxon_name_is_safe(taxonlabel.taxonomicname));
|
|
| 8844 | 8844 |
|
| 8845 | 8845 |
|
| 8846 | 8846 |
-- |
Also available in: Unified diff
bugfix: schemas/public_.sql: tnrs_input_name: need to exclude unsafe taxon names as a workaround to #935 (TNRS crashes when scrubbing names with two infraspecific epithets)