Douglas Toltzman <[EMAIL PROTECTED]> writes: > It was my understanding that a NULL value would be not-equal to any > non-null value. Am I wrong about this?
Yes. A NULL is neither equal nor unequal to anything else.
You can use IS DISTINCT FROM to get the behavior you are looking for,
but it might be better to rethink how you are using NULL.
regards, tom lane
---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings
