"K. Haley" <[EMAIL PROTECTED]> wrote: > > > > But its worse than that, in that SQL isn't even consistent with itself > > in how it treats nulls. With some kinds of operations or queries, it > > treats every null being unique, and in other situations it treats them > > all as being equal. No normal data type has this problem. > What situations treat them all as being equal? Off hand I can't think > of any, but then my SQL experience isn't that broad.
Every SQL engine I have tested treats NULLs as equal in the following contexts: * ORDER BY * SELECT DISTINCT ... * SELECT ... UNION SELECT .... -- D. Richard Hipp <[EMAIL PROTECTED]>
