Re: [Info-Ingres] Why BOOLEAN data type not provided in Ingres

We do support boolean in a virtual sense in adf in the comparison operators and logical operators in the parser but these have never been instanciated as a formal type in the database. I think there were once supported types of BIT and BITVECTOR but not BOOLEAN.
Regards,
Ian
-----Original Message-----
From: info-ingres-bounces@xxxxxxxxxxxxxxxxxxxxxxxxx [mailto:info-ingres-bounces@xxxxxxxxxxxxxxxxxxxxxxxxx] On Behalf Of Roy Hann
Sent: 13 February 2008 08:30
To: info-ingres@xxxxxxxxxxxxxxxxxxxxxxxxx
Subject: Re: [Info-Ingres] Why BOOLEAN data type not provided in Ingres

"Laframboise André" <andre.laframboise@xxxxxxxxxxxxx> wrote in message
news:mailman.31.1202883873.2607.info-ingres@xxxxxxxxxxxxxxxxxxxxxxxxxxxx
Hi Srikanth,

I don't think boolean is part of the SQL standard. AFAIK, the only
mainstream DB that supports it
is MySQL (sort of).

Most use char(1) or number(1) to emulate boolean type values (1,0,'T','F',
etc).

Or varchar(1). :-(

A boolean type would have the slight advantage of a limited, well-known set
of possible values, but not much else.

Roy



.

Relevant Pages

  • Re: Using expressions in a SELECT Clause
    ... There is no BOOLEAN data type in SQL. ... SQL-92 has no boolean data type, but the current SQL standard ... type also supports the unknown truth value as the null value. ...
    (microsoft.public.sqlserver.programming)
  • Re: On exit event
    ... Did Access Basic have a Boolean data type in its first incarnation? ... Doug Steele, Microsoft Access MVP ...
    (microsoft.public.access.modulesdaovba)
  • Re: Update Status Field after Expiry Date
    ... represent it in the context of the Boolean data type as well. ... IINM, while SQL doesn't have a mandatory Boolean *type*, it already ... *expressions*. ...
    (comp.databases.ms-sqlserver)
  • Re: Comparison operator in Select list
    ... SQL Server does not support a boolean data type, ... A boolean expression can only be used in an IF statement, ...
    (comp.databases.ms-sqlserver)
  • Re: [Info-Ingres] Why BOOLEAN data type not provided in Ingres
    ... I don't think boolean is part of the SQL standard. ... mainstream DB that supports it ... is MySQL (sort of). ...
    (comp.databases.ingres)