Re: Should IS DISTINCT FROM work with ANY()? - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Should IS DISTINCT FROM work with ANY()?
Date
Msg-id 16043.1233280246@sss.pgh.pa.us
Whole thread Raw
In response to Re: Should IS DISTINCT FROM work with ANY()?  (David Fetter <david@fetter.org>)
Responses Re: Should IS DISTINCT FROM work with ANY()?  ("David E. Wheeler" <david@kineticode.com>)
List pgsql-hackers
David Fetter <david@fetter.org> writes:
> On Thu, Jan 29, 2009 at 08:12:12PM -0500, Tom Lane wrote:
>> "David E. Wheeler" <david@kineticode.com> writes:
>>> Seems to me that IS DISTINCT FROM is just another operator, like =,  
>> 
>> Wishful thinking...

> What would it take to make this wish come true?

I don't think we want it to come true.  If we treat IS DISTINCT FROM
as a weirdly-named operator then we have to provide an implementation
for every datatype (oh, and another one for IS NOT DISTINCT FROM).
The PITA factor is enormous.  Much better to handle it the way we
are now, where it's a specialized expression node type.

To get it to work with ANY/ALL you'd probably need some special hack to
create new sublink types, or something like that.  Also a PITA, but
a lot more localized ...
        regards, tom lane


pgsql-hackers by date:

Previous
From: David Fetter
Date:
Subject: Re: Should IS DISTINCT FROM work with ANY()?
Next
From: Euler Taveira de Oliveira
Date:
Subject: Re: reloptions with a "namespace"