Re: Need efficient way to do comparison with NULL as an option - Mailing list pgsql-general

"D. Dante Lorenso" <dante@lorenso.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