On Oct 20, 2005, at 15:44 , Michael Fuhr wrote:
expression IS DISTINCT FROM expression
For non-null inputs this is the same as the <> operator. However,
when both inputs are null it will return false, and when just one
input is null it will return true. Thus it effectively acts as
though null were a normal data value, rather than "unknown".
Interesting! Thanks, Michael. You don't happen to know off the top of
your head if that's standard SQL, do you?
Michael Glaesemann
grzm myrealbox com
---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?
http://archives.postgresql.org
