On Sat, 2004-04-24 at 05:56, Jesse Norell wrote: > AFAIK, those are only used for boolean values, and changing the schema > there could probably save a small bit of space. You would have to have > different sql syntax for mysql and postgres doing that, though, so perhaps > that's why they're not. (postgres requires "where *_flag = B'1' ...")
Yup. That's it. We need to have similar queries for PostgreSQL and Mysql (and Oracle). Besides, AFAIK Boolean is not an SQL-92 datatype.
