Edmund Dengler <edmundd@eSentire.com> 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