I like Postgres's boolean type - why do you suppose neither Mysql nor Oracle has bothered to implement it? Booleans are in the SQL-99 spec.
from the mySQL manual on Overview of Numeric Types:
BOOL , BOOLEAN These are synonyms for TINYINT(1). The BOOLEAN synonym was added in MySQL 4.1.0. A value of zero is considered false. Non-zero values are considered true. In the future, full boolean type handling will be introduced in accordance with standard SQL.
BOOL , BOOLEAN
These are synonyms for TINYINT(1). The BOOLEAN synonym was added in MySQL 4.1.0. A value of zero is considered false. Non-zero values are considered true.
In the future, full boolean type handling will be introduced in accordance with standard SQL.
