Re: 0/1 vs true/false

On Wed, 23 Jul 2003, Tom Lane wrote:

> "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.

Yep, you're right.  I was looking at how they treated booles in search
conditions, and figured they had a type to match.