Revision 10326
Added by Aaron Marcuse-Kubitza over 11 years ago
| inputs/REMIB/Specimen/create.sql | ||
|---|---|---|
| 1 |
-- runtime: 7 s ("Time: 6888.394 ms")
|
|
| 1 | 2 |
SELECT * |
| 2 | 3 |
FROM "Specimen.src" |
| 3 | 4 |
WHERE |
| 4 | 5 |
acronym IS NOT NULL |
| 5 | 6 |
AND coll_year ~ E'^(?:1[7-9]|20)\\d{2}$'
|
| 6 | 7 |
AND country !~ E'\\d' |
| 8 |
AND (long_deg !~ E'[[:alpha:]]' OR long_deg IN ('RESTRINGIDO'))
|
|
Also available in: Unified diff
inputs/REMIB/Specimen/create.sql: also remove frameshifted rows with invalid long_deg values