Revision 13152
Added by Aaron Marcuse-Kubitza over 10 years ago
| trunk/inputs/NY/validations.sql | ||
|---|---|---|
| 131 | 131 |
CREATE VIEW _specimens_07_list_of_verbatim_subspecific_taxa_with_author AS |
| 132 | 132 |
SELECT DISTINCT "Ecatalog_all"."scientificName" AS taxon_name_with_author |
| 133 | 133 |
FROM "Ecatalog_all" |
| 134 |
WHERE ((("Ecatalog_all".genus IS NOT NULL) AND ("Ecatalog_all"."specificEpithet" IS NOT NULL)) AND ("Ecatalog_all".subspecies IS NOT NULL));
|
|
| 134 |
WHERE ("Ecatalog_all".subspecies IS NOT NULL);
|
|
| 135 | 135 |
|
| 136 | 136 |
|
| 137 | 137 |
-- |
Also available in: Unified diff
bugfix: inputs/NY/validations.sql: _specimens_07_list_of_verbatim_subspecific_taxa_with_author: updated filter condition to match output query