--- In firebird-support@yahoogroups.com, Milan Babuskov <milanb@...>
wrote:

>
> javaguru_uk wrote:

Milan> You can easily add boolean type via domains:

Milan> CREATE DOMAIN BOOLEAN
Milan> AS SMALLINT
Milan> CHECK (value is null or value in (0, 1));

Milan> And use it like this:

Milan> CREATE TABLE t1
Milan> (
Milan> C1 VARCHAR(10),
Milan> B1 BOOLEAN,
Milan> B2 BOOLEAN NOT NULL,
Milan> ...
Milan> );

Milan> As you can see, not much different than 'real' boolean.

Hi Milan, I am aware of this. My question is regarding support for
true booleans.

You have easily done the following:

create domain boolean char(1) check (value is null or value in ('T', 'F');

But you can't really use true or false values. And it sucks having to
declare domains all the time.