Revision 10335
Added by Aaron Marcuse-Kubitza about 11 years ago
| postprocess.sql | ||
|---|---|---|
| 7 | 7 |
DELETE FROM :table WHERE acronym IS NULL; |
| 8 | 8 |
DELETE FROM :table WHERE coll_year !~ E'^(?:1[7-9]|20)\\d{2}$';
|
| 9 | 9 |
DELETE FROM :table WHERE country ~ E'\\d'; |
| 10 |
DELETE FROM :table WHERE (long_deg ~ E'[[:alpha:]]' AND long_deg NOT IN ('RESTRINGIDO'));
|
|
| 10 |
DELETE FROM :table WHERE long_deg ~ E'[[: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: remove frameshifted rows: removed unnecessary () around `DELETE FROM :table WHERE long_deg ...`