Mike Mascari <[EMAIL PROTECTED]> writes: > I curious if any of the rewriting of EXISTS and NOT EXISTS would > address the problem described by Date:
> http://www.firstsql.com/iexist.htm We are not here to redefine the SQL spec ... and especially not to eliminate its concept of NULL, which is what Date would really like ;-) The above-quoted screed is based on a claimed logical equivalence between NOT EXISTS() and NOT IN() that is just plain wrong when you consider the possibility of NULLs. Rather than "FirstSQL correctly processes this query", you should read "FirstSQL deliberately violates the SQL spec". (There may be grounds to argue that the spec behavior could be improved, but that's an argument to be making to the standards committee, not here.) regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
