At 10:30 AM 12/24/2001 -0500, Paul Schmidt wrote:

>create domain D_BOOL as integer DEFAULT 0 CHECK (VALUE IN
>(0,1)) not null;
>
>This effectively creates a boolean type, although it uses more
>storage then it needs to.

If you make the type char(1), it will be about the same as
the optimal ... at the moment we don't shuffle the physical
representation to cluster like types together. If we did,
then the first boolean field would take a byte and the next
seven would be free.... which seems crazy given the price
of disks...


Regards,

Ann
www.ibphoenix.com
We have answers.