root/trunk/inputs/bien2_traits/TraitObservation/postprocess.sql
| 1 |
SELECT util.search_path_append('util'); |
|---|---|
| 2 |
|
| 3 |
|
| 4 |
-- remove invalid rows
|
| 5 |
|
| 6 |
-- remove rows with no taxon name
|
| 7 |
-- this also helps simplify the aggregating validations queries
|
| 8 |
DELETE FROM :table WHERE "taxonName" IS NULL |
| 9 |
-- removes 12571 of 122230 rows (122230 - 109659)
|
| 10 |
; -- runtime: 0.3 s ("288.312 ms") @starscream |