Martijn van Oosterhout <kleptog@svana.org> writes:
> My Plan B was to create a operator IS (and its inverse ISNOT) which is then
> binary operator. It would be identical to =3D and <> except that it would be
> defined where either argument is NULL. Fiddle the parser to use this
> operator instead of the unary ISNULL.
I don't think there's anything fundamental that assumes that indexable
operators are binary, so you might as well make the operator unary. The
problem with this approach isn't that --- it's the tedium of making an
ISNULL operator for every datatype, adding it to every opclass, etc.
Maybe there's no non-kluge answer that doesn't make us buy into that,
but it sure seems like the hard way. It's definitely not going to be
a short and sweet patch :-(
regards, tom lane