title: In SQL how to select tuples whose "character varying(5)" column values are fixed size?
body: <p>For example I have this table with a zipcode column(zipcode character varying(5)) but some of "bad" rows have invalid zipcode like "9000" or "2". and I want all the tuples whose zipcode values have exactly 5 characters.</p>
  
  <p>How to translate </p>
  
  <pre><code>SELECT * FROM mytable WHERE zipcode "is size 5" 
  </code></pre>
  
  <p>to SQL?</p>
  
  <p>I am using postgresql btw.</p>