Project

General

Profile

« Previous | Next » 

Revision 10340

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.

View differences:

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