Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- -- QA ATT_A
- SELECT *
- FROM census.code
- where length(trim(ATT_A)) != 5
- or ATT_A ~ E'[A-Za-z]+';
- -- QA ATT_B
- SELECT *
- FROM census.code
- where length(trim(ATT_B)) != 9
- or (ATT_B not like '%ND' and ATT_B ~ E'[A-Za-z]+');
- -- QA ATT_C
- SELECT *
- FROM census.code
- where length(trim(ATT_C)) != 4
- or (ATT_C not like '%ND' and ATT_C ~ E'[A-Za-z]+');
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement