Revision 13635
Added by Aaron Marcuse-Kubitza over 10 years ago
| trunk/schemas/public_.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)) AND "TNRS".taxon_name_is_safe(taxonlabel.taxonomicname));
|
|
| 8843 |
WHERE (((taxonlabel.taxonomicname IS NOT NULL) AND ("MatchedTaxon"."concatenatedScientificName" IS NULL)) AND "TNRS".taxon_name_is_safe(taxonlabel.taxonomicname))
|
|
| 8844 |
ORDER BY taxonlabel.taxonomicname; |
|
| 8844 | 8845 |
|
| 8845 | 8846 |
|
| 8846 | 8847 |
-- |
| trunk/schemas/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)) AND "TNRS".taxon_name_is_safe(taxonlabel.taxonomicname));
|
|
| 8843 |
WHERE (((taxonlabel.taxonomicname IS NOT NULL) AND ("MatchedTaxon"."concatenatedScientificName" IS NULL)) AND "TNRS".taxon_name_is_safe(taxonlabel.taxonomicname))
|
|
| 8844 |
ORDER BY taxonlabel.taxonomicname; |
|
| 8844 | 8845 |
|
| 8845 | 8846 |
|
| 8846 | 8847 |
-- |
Also available in: Unified diff
fix: schemas/public_.sql: tnrs_input_name: added ORDER BY to ensure a stable sort order. this also creates better query plans by enabling merge joins.