title: What's wrong with my CASE?
body: <blockquote>
    <p><code>CASE WHEN table1.text IS NULL THEN table2.numbers
    ELSE table1.text
    END AS newcolumn</code></p>
  </blockquote>
  
  <p>When running this code I keep getting this error: 
  <strong>ERROR:  CASE types character varying and integer cannot be matched</strong></p>
  
  <p>You would think that this would not cause problems since I'm creating a new column within my query. I'd also like to point out that I'm using an old version of PostgreSQL if that helps.</p>