title: Someway to do `where booleanvalue=false` on both Sql Server and PostgreSQL?
body: <p>I am attempting to make an application capable of running on both Sql Server and PostgreSQL. </p>
  
  <p>I can not seem to find a common expression that is basically</p>
  
  <pre><code> select * from table where booleancol=false
  </code></pre>
  
  <p>on SQL Server I must do(which is very confusing because the default value for bit types must be true or false, but you can't assign them to true or false or test against it)</p>
  
  <pre><code>select * from table where booleancol=0
  </code></pre>
  
  <p>on PostgreSQL I must do</p>
  
  <pre><code>select * from table where booleancol is false
  </code></pre>
  
  <p>There are quite a lot of queries in our program that does this, so I'd prefer if there was just some universal syntax I could use instead of doing <code>if(dbformat=="postgres")..</code> type crap.. </p>
  
  <p>Also, I'd prefer to leave the columns as boolean/bit types and not change them to integer types.. though that is an option..</p>