Zeugswetter Andreas SB <[EMAIL PROTECTED]> writes:
> Thus it could be, that NULL in "where column = NULL" is not defined
> to have a special meaning according to SQL92.
The way I interpret Celko's interpretation of SQL92, that specific
construct has a meaning; it evaluates to UNKNOWN, thus not to TRUE,
and the WHERE clause becomes useless, as does any other combination of
a theta operator and the explicit constant 'NULL'. This is almost,
but not quite, an argument for allowing "= NULL" for "IS NULL". ;-)
Does anyone out there have the actual text of the standard?
-tih
--
The basic difference is this: hackers build things, crackers break them.
---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/users-lounge/docs/faq.html
