root/inputs/MO/Specimen/postprocess.sql @ 7700
| 1 |
-- Remove frameshifted rows by detecting InstitutionCodes without any letters
|
|---|---|
| 2 |
DELETE FROM "MO"."Specimen" |
| 3 |
WHERE NOT COALESCE("InstitutionCode" ~ '[[:alpha:]]', false) |
| 4 |
;
|