root/inputs/REMIB/Specimen/create.sql @ 10329
| 1 |
-- runtime: 7 s ("Time: 6888.394 ms")
|
|---|---|
| 2 |
SELECT * |
| 3 |
FROM "Specimen.src" |
| 4 |
WHERE
|
| 5 |
acronym IS NOT NULL |
| 6 |
AND coll_year ~ E'^(?:1[7-9]|20)\\d{2}$' |
| 7 |
AND country !~ E'\\d' |
| 8 |
AND (long_deg !~ E'[[:alpha:]]' OR long_deg IN ('RESTRINGIDO')) |