root/inputs/REMIB/Specimen/create.sql @ 7646
1 |
SELECT * |
---|---|
2 |
FROM "Specimen.src" |
3 |
WHERE
|
4 |
acronym IS NOT NULL |
5 |
AND coll_year ~ E'^(?:1[7-9]|20)\\d{2}$' |
6 |
AND country !~ E'\\d' |