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