> > > > > > Did anyone test or try Interbase 7? I
> > > > >
> > > > > It's not available yet.
> > > >
> > > > It is now, lets all not get too excited about the boolean data type

<g>

> > >
> > > Is that a real boolean type, or is it simply another name for an int?
> >
> > According to the samples in the paper, you should be able to do:
> >
> > WHERE booleancolumn = TRUE
> >
> > So it behaves like a true (*g*) boolean.
>
> Nice ;-), but this reminds me where I have corrected programming
> exercises of rather new computer science students, where in some
> cases, IF statements looked like:
>
> IF (MYBOOLEAN = TRUE) THEN
> MYBOOLEAN := FALSE;
> ELSE
> MYBOOLEAN := TRUE;
> END;
>
> ;-)).

Yups - I know about this one ...

I'm not sure how the SQL standard says a BOOLEAN should be
handled in cases of a WHEN clause.

> So, a boolean column in a WHERE should be evaluated without using
> TRUE/FALSE ;-).
>
> Like:
> WHERE ID < 1000 AND BOOLEANCOLUMN
> or
> WHERE ID < 1000 AND NOT BOOLEANCOLUMN
>
> ....
>
> The same of course should apply for example for IF statements in
> triggers and stored procedures ... ;-).

I guess this works just fine... But we'll have to wait for that.


With regards,

Martijn Tonies
InterBase Workbench - the developer tool for InterBase
http://www.upscene.com

Firebird Workbench - the developer tool for Firebird
http://www.upscene.com

Upscene Productions
http://www.upscene.com

"This is an object-oriented system.
If we change anything, the users object."