On Wed, 23 Jul 2003, Tom Lane wrote:
> "scott.marlowe" <[EMAIL PROTECTED]> 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.
---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
