"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.
regards, tom lane
---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match
