As i understand it, the use of NULL in SQL means the value of the column
is unknown. Therefore that result would seem fair.
Havasvölgyi Ottó wrote:
Hi,
I have just run this command on 8.0.4 :
SELECT 'foo' WHERE 0 NOT IN (NULL, 1);
And it resulted is zero rows.
Without NULL it is OK.
Is this
how about an very large table with a "processed" type flag?
uru
-Dave
Marc G. Fournier wrote:
Does that make sense? Would it ever get used? I can't see it, but
figured I'd ask ...
Marc G. Fournier Hub.Org Networking Services (http://www.hub.org)
Email: [EMAIL PROTECTED]
