Revision 14429
Added by Aaron Marcuse-Kubitza over 10 years ago
| trunk/schemas/public_.sql | ||
|---|---|---|
| 11638 | 11638 |
CREATE VIEW tnrs_input_name AS |
| 11639 | 11639 |
SELECT DISTINCT taxonlabel.taxonomicname |
| 11640 | 11640 |
FROM (taxonlabel |
| 11641 |
LEFT JOIN "TNRS".taxon_best_match ON ((taxon_best_match."*Name_submitted" = taxonlabel.taxonomicname)))
|
|
| 11642 |
WHERE (((taxonlabel.taxonomicname IS NOT NULL) AND (taxon_best_match."*Name_submitted" IS NULL)) AND "TNRS".taxon_name_is_safe(taxonlabel.taxonomicname))
|
|
| 11641 |
LEFT JOIN "TNRS".taxon_match ON ((taxon_match."*Name_submitted" = taxonlabel.taxonomicname)))
|
|
| 11642 |
WHERE (((taxonlabel.taxonomicname IS NOT NULL) AND (taxon_match."*Name_submitted" IS NULL)) AND "TNRS".taxon_name_is_safe(taxonlabel.taxonomicname)) |
|
| 11643 | 11643 |
ORDER BY taxonlabel.taxonomicname; |
| 11644 | 11644 |
|
| 11645 | 11645 |
|
| trunk/schemas/vegbien.sql | ||
|---|---|---|
| 11638 | 11638 |
CREATE VIEW tnrs_input_name AS |
| 11639 | 11639 |
SELECT DISTINCT taxonlabel.taxonomicname |
| 11640 | 11640 |
FROM (taxonlabel |
| 11641 |
LEFT JOIN "TNRS".taxon_best_match ON ((taxon_best_match."*Name_submitted" = taxonlabel.taxonomicname)))
|
|
| 11642 |
WHERE (((taxonlabel.taxonomicname IS NOT NULL) AND (taxon_best_match."*Name_submitted" IS NULL)) AND "TNRS".taxon_name_is_safe(taxonlabel.taxonomicname))
|
|
| 11641 |
LEFT JOIN "TNRS".taxon_match ON ((taxon_match."*Name_submitted" = taxonlabel.taxonomicname)))
|
|
| 11642 |
WHERE (((taxonlabel.taxonomicname IS NOT NULL) AND (taxon_match."*Name_submitted" IS NULL)) AND "TNRS".taxon_name_is_safe(taxonlabel.taxonomicname)) |
|
| 11643 | 11643 |
ORDER BY taxonlabel.taxonomicname; |
| 11644 | 11644 |
|
| 11645 | 11645 |
|
Also available in: Unified diff
bugfix: schemas/public_.sql: tnrs_input_name: use taxon_match instead of taxon_best_match because there is no index on taxon_match that includes just the filters used by taxon_best_match