Re: Equality operators on NULL values - Mailing list pgsql-sql

Bertrand Petit writes:

>         NULL=NULL ==> t
>         1=NULL    ==> NULL (or anything else as long as it is not t)
>         1=1       ==> t
>         1=2       ==> f

>     Is there a stock replacement operator that would behave like
> the second truth table?

No, but why not write

(a = b) or (a is null and b is null)

-- 
Peter Eisentraut   peter_e@gmx.net