Revision 13107
Added by Aaron Marcuse-Kubitza over 10 years ago
| trunk/inputs/NY/validations.sql | ||
|---|---|---|
| 74 | 74 |
CREATE VIEW _specimens_04_count_of_species_binomials AS |
| 75 | 75 |
SELECT count(DISTINCT concat_ws(' '::text, "Ecatalog_all".genus, "Ecatalog_all"."specificEpithet")) AS species_binomials
|
| 76 | 76 |
FROM "Ecatalog_all" |
| 77 |
WHERE ((("Ecatalog_all".genus IS NOT NULL) AND ("Ecatalog_all"."specificEpithet" IS NOT NULL)) AND ("Ecatalog_all".subspecies IS NOT NULL));
|
|
| 77 |
WHERE (("Ecatalog_all".genus IS NOT NULL) AND ("Ecatalog_all"."specificEpithet" IS NOT NULL));
|
|
| 78 | 78 |
|
| 79 | 79 |
|
| 80 | 80 |
-- |
| ... | ... | |
| 93 | 93 |
CREATE VIEW _specimens_05_list_of_species_binomials AS |
| 94 | 94 |
SELECT DISTINCT concat_ws(' '::text, "Ecatalog_all".genus, "Ecatalog_all"."specificEpithet") AS species_binomial
|
| 95 | 95 |
FROM "Ecatalog_all" |
| 96 |
WHERE ((("Ecatalog_all".genus IS NOT NULL) AND ("Ecatalog_all"."specificEpithet" IS NOT NULL)) AND ("Ecatalog_all".subspecies IS NOT NULL));
|
|
| 96 |
WHERE (("Ecatalog_all".genus IS NOT NULL) AND ("Ecatalog_all"."specificEpithet" IS NOT NULL));
|
|
| 97 | 97 |
|
| 98 | 98 |
|
| 99 | 99 |
-- |
Also available in: Unified diff
bugfix: inputs/NY/validations.sql: specimens*_of_species_binomials: removed incorrect `subspecies IS NOT NULL` filter (this should be on *_of_unique_verb_subsp_taxa_with_author instead)