Re: Planning for improved versions of IN/NOT IN

Mike Mascari <mascarm(at)mascari(dot)com> 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