"D. Dante Lorenso" <dante(at)lorenso(dot)com> writes:
> I'm looking for an operator that will compare NULL with NULL and
> evaluate as TRUE.
regression=# select null IS NOT DISTINCT FROM 42;
?column?
----------
f
(1 row)
regression=# select null IS NOT DISTINCT FROM null;
?column?
----------
t
(1 row)
However, if you're expecting this to be real efficient (like, use an
index), you're out of luck ...
> If the value I'm comparing is 0, I want it to match the NULL values.
[ raised eyebrow... ] Sir, you need to rethink your data
representation.
regards, tom lane