Edmund Dengler <[EMAIL PROTECTED]> writes: > What I want is an '=' that compares nulls as equal (rather than as > not-equal, which is the normal case).
IS DISTINCT FROM may help you here. It's a not-equals operator rather than an equals operator, but it does what you want. (Unless what you wanted included being able to use an index...) regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives? http://archives.postgresql.org