Revision 10336
Added by Aaron Marcuse-Kubitza over 11 years ago
| inputs/REMIB/Specimen/postprocess.sql | ||
|---|---|---|
| 5 | 5 |
-- remove frameshifted rows |
| 6 | 6 |
-- rerun time: 6 s ("Time: 5537.211 ms") thanks to index
|
| 7 | 7 |
DELETE FROM :table WHERE acronym IS NULL; |
| 8 |
DELETE FROM :table WHERE coll_year !~ E'^(?:1[7-9]|20)\\d{2}$';
|
|
| 9 |
DELETE FROM :table WHERE country ~ E'\\d';
|
|
| 10 |
DELETE FROM :table WHERE long_deg ~ E'[[:alpha:]]' AND long_deg NOT IN ('RESTRINGIDO');
|
|
| 8 |
DELETE FROM :table WHERE coll_year !~ '^(?:1[7-9]|20)\d{2}$';
|
|
| 9 |
DELETE FROM :table WHERE country ~ '\d';
|
|
| 10 |
DELETE FROM :table WHERE long_deg ~ '[[:alpha:]]' AND long_deg NOT IN ('RESTRINGIDO');
|
|
| 11 | 11 |
|
| 12 | 12 |
-- Remove institutions that we have direct data for |
| 13 | 13 |
DELETE FROM :table |
Also available in: Unified diff
inputs/REMIB/Specimen/postprocess.sql: change E'' to regular '' to avoid the need to double \ (instead ' would be doubled). E'' used to be necessary in previous versions of PostgreSQL to avoid a warning about escape string syntax.