Search code examples
sql-serverpostgresqlcompatibilityansi-sql

Someway to do `where booleanvalue=false` on both Sql Server and PostgreSQL?

I am attempting to make an application capable of running on both Sql Server and PostgreSQL.

I can not seem to find a common expression that is basically

 select * from table where booleancol=false

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)

select * from table where booleancol=0

on PostgreSQL I must do

select * from table where booleancol is false

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 if(dbformat=="postgres").. type crap..

Also, I'd prefer to leave the columns as boolean/bit types and not change them to integer types.. though that is an option..

Solution

  • SQL Server will automatically change the bit value to the varchar value of true or false. So the following works there:

    select * from table where booleancol = 'false'

    I have no idea if postgre does the same thing.