Re: [CLSQL-Help] inserting FALSE

bsd1628 wrote:
> FWIW, there is no boolean type for tables in the Oracle relational 
> model.  An attribute value either exists or it does not.  The concept of 
> boolean value exists at the programmatic level in PL/SQL.

Thanks for the info. Yet another complication to creating a model to
well-supporting booleans on all backends. As another example, MySQL has a
boolean type which is identical to a TINYINT (8-bit signed number)
whereas postgresql seems to be only to (maybe?) have a 'real' boolean
type. IIRC, postgresql acts like a CHAR(1) with storing 't' and 'f',
but like MySQL, can use a boolean field (like active_row) in a WHERE clause
"SELECT rowid FROM FOO WHERE active_row"

Kevin


-- 
Kevin Rosenberg
[email protected]