Revision 4945
Added by Aaron Marcuse-Kubitza about 12 years ago
| inputs/REMIB/Specimen/create.sql | ||
|---|---|---|
| 1 | 1 |
SELECT * |
| 2 | 2 |
FROM "Specimen.src" |
| 3 |
WHERE coll_year ~ E'^(?:1[7-9]|20)\\d{2}$' AND country !~ E'\\d'
|
|
| 3 |
WHERE |
|
| 4 |
acronym IS NOT NULL |
|
| 5 |
AND coll_year ~ E'^(?:1[7-9]|20)\\d{2}$'
|
|
| 6 |
AND country !~ E'\\d' |
|
Also available in: Unified diff
inputs/REMIB/Specimen/create.sql: Also filter out rows where acronym (collectionCode) is NULL because this is a required field for valid records