title: Using CASE WHEN on boolean columns
body: <p>This is Postgres 8.x. Speicifcally Redshift.</p>
  
  <p>Table has all FALSE in all the 3 columns. However, when I run this query, it returns as if all are <code>TRUE</code>.</p>
  
  <pre><code>SELECT
  count(CASE WHEN facebook THEN 1 ELSE 0 END)
  , count(CASE WHEN instagram THEN 1 ELSE 0 END)
  , count(CASE WHEN twitter THEN 1 ELSE 0 END)
  FROM public.sampletable
  </code></pre>
  
  <p>Not sure what I'm doing wrong. I've also tried <code>CASE WHEN facebook = TRUE</code></p>
  
  <p>I've made sure the cells aren't NULL or anything as well</p>