Advertisement
Guest User

Untitled

a guest
Oct 31st, 2014
144
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.36 KB | None | 0 0
  1. -- QA ATT_A
  2.  
  3. SELECT *
  4. FROM census.code
  5. where length(trim(ATT_A)) != 5
  6. or ATT_A ~ E'[A-Za-z]+';
  7.  
  8. -- QA ATT_B
  9.  
  10. SELECT *
  11. FROM census.code
  12. where length(trim(ATT_B)) != 9
  13. or (ATT_B not like '%ND' and ATT_B ~ E'[A-Za-z]+');
  14.  
  15. -- QA ATT_C
  16.  
  17. SELECT *
  18. FROM census.code
  19. where length(trim(ATT_C)) != 4
  20. or (ATT_C not like '%ND' and ATT_C ~ E'[A-Za-z]+');
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement