Revision 10340
Added by Aaron Marcuse-Kubitza almost 11 years ago
| inputs/REMIB/Specimen/postprocess.sql | ||
|---|---|---|
| 17 | 17 |
SELECT create_if_not_exists($$CREATE INDEX "Specimen.acronym" ON $$||:table_str||$$ (acronym)$$); |
| 18 | 18 |
|
| 19 | 19 |
-- remove frameshifted rows |
| 20 |
-- rerun time: 6 s ("Time: 5537.211 ms") thanks to index
|
|
| 21 | 20 |
DELETE FROM :table WHERE acronym IS NULL; |
| 22 | 21 |
DELETE FROM :table WHERE coll_year !~ '^(?:1[7-9]|20)\d{2}$';
|
| 23 | 22 |
DELETE FROM :table WHERE country_verbatim ~ '\d'; |
Also available in: Unified diff
inputs/REMIB/Specimen/postprocess.sql: remove frameshifted rows: removed out-of-date rerun time, which applied to doing all the deletes in the same statement (however, the current rerun time is approximately the same). note that index scans are not actually used (as the previous comment incorrectly stated) because the conditions for this filter are prefix-less regexps.