Re: BOOLEAN data type?

Tom,

> Are you taking into account that SQL booleans are actually
> three-valued?
> They can be TRUE, FALSE, or NULL (NULL taken as meaning "don't
> know").

That turned out not to be the issue, but that's good information to
have. I'll need to remember to make all of my BOOLEAN columns NOT NULL
DEFAULT FALSE.

-Josh

______AGLIO DATABASE SOLUTIONS___________________________
Josh Berkus
Complete information technology josh(at)agliodbs(dot)com
and data management solutions (415) 565-7293
for law firms, small businesses fax 621-2533
and non-profit organizations. San Francisco