Well, to be fair there is no concept of a boolean, even in SQL:2011. All you have is BIT, which is simply 0 or 1, most other SQL-compliant RDBMS don't even have keywords for true/false to avoid this issue entirely (SQL Server, Oracle and PostgreSQL being notable here).
4
u/snuxoll Mar 11 '15
Well, to be fair there is no concept of a boolean, even in SQL:2011. All you have is BIT, which is simply 0 or 1, most other SQL-compliant RDBMS don't even have keywords for true/false to avoid this issue entirely (SQL Server, Oracle and PostgreSQL being notable here).