Revision 12945
Added by Aaron Marcuse-Kubitza almost 11 years ago
| trunk/validation/aggregating/specimens/NY/qualitative_validations_source_db_NYBG.VegCore.sql | ||
|---|---|---|
| 22 | 22 |
*/ |
| 23 | 23 |
|
| 24 | 24 |
-- _specimens_03_list_of_verbatim_families |
| 25 |
SELECT DISTINCT concat_ws(' '::text, "Ecatalog_all".genus, "Ecatalog_all"."specificEpithet") AS "specificEpithet"
|
|
| 25 |
SELECT DISTINCT "Ecatalog_all".family AS family
|
|
| 26 | 26 |
FROM "Ecatalog_all" |
| 27 | 27 |
WHERE (("Ecatalog_all".genus IS NOT NULL) AND ("Ecatalog_all"."specificEpithet" IS NOT NULL));
|
| 28 | 28 |
/* |
Also available in: Unified diff
validation/aggregating/specimens/NY/qualitative_validations_source_db_NYBG.VegCore.sql: stage I: clarified that the database input is intended to be a normalized input, and its corresonding output is intended to be denormalized