On Wed, 23 Jul 2003, Tom Lane wrote:

> Jean-Christian Imbeault <[EMAIL PROTECTED]> writes:
> > Oops, I meant to say can someone point me to a ressource (SQL standard
> > and section?) which states that true/false must be used for booleans :)
> 
> Well, there is no boolean type per se in SQL92.  But there is in SQL99.
> I think the most relevant part of the spec is the definition of boolean
> literals in section 5.3:
> 
>          <boolean literal> ::=
>                 TRUE
>               | FALSE
>               | UNKNOWN

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.

further, intermediate SQL compliance has this in it:

24)Subclause 8.12, "<search condition>":

            a) A <boolean test> shall not specify a <truth value>.

Does that mean you should only use the "is true" suntax, not the =true?




---------------------------(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

Reply via email to