Subject Re: [ib-support] Re: Char set & collation order ... I'm lost!
Author Ann W. Harrison
At 12:33 PM 12/27/2001 -0500, Paul Schmidt wrote:

>What we need is a bool type which assigns a single byte, using
>the first bit of that byte, then when the next boolean is created it
>uses the second bit, until you either run out of boolean fields, or
>the byte is full. If the byte is full, it assigns another byte. A
>number of other databases do this, so perhaps we can too.

We >can< do almost anything. The question is what >should< we do
with limited resources?

Beyond that boolean datatypes worry me semantically - not the domains,
which people seem to be able to live with, but real boolean types.
Assuming that c1 is a boolean column, I would expect to be able to
do this:

where t1.c1 or t1.c2 = 12
set t1.c1 = NOT t1.c1

That's going to require applying force and violence to Claudio's
well beloved parser.


We have answers.