Re: 0/1 vs true/false

"scott.marlowe" <scott.marlowe@ihs.com> writes:
> On Wed, 23 Jul 2003, Tom Lane wrote:
>> Well, there is no boolean type per se in SQL92.  But there is in SQL99.

> Was it pulled from SQL92 before it went standard?  My copy of the
> pre-release lists a boolean type, just like the 99 standard does.

Where?  SQL92 says nothing about a declarable boolean datatype that
I can see.  They're a bit schizophrenic in that they do define a lot
of operators that are described as returning boolean ... but you cannot
create a column of type boolean, nor is there a boolean-literal construct.
AFAICS, boolean values can only exist "in flight" between operators and
a WHERE or HAVING clause in SQL92.

            regards, tom lane