root/trunk/inputs/bien2_traits/TraitObservation/postprocess.sql
| 1 | 12060 | aaronmk | 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 |