Re: Add IS (NOT) DISTINCT to subquery_Op - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Add IS (NOT) DISTINCT to subquery_Op
Date
Msg-id 656.1449795829@sss.pgh.pa.us
Whole thread Raw
In response to Add IS (NOT) DISTINCT to subquery_Op  (Jim Nasby <Jim.Nasby@BlueTreble.com>)
Responses Re: Add IS (NOT) DISTINCT to subquery_Op  (Jim Nasby <Jim.Nasby@BlueTreble.com>)
List pgsql-hackers
Jim Nasby <Jim.Nasby@BlueTreble.com> writes:
> Is there any reason we couldn't/shouldn't support IS DISTINCT in 
> subquery_Op? (Or really, just add support to ANY()/ALL()/(SELECT ...)?)

It's not an operator (in the sense of something with a pg_operator OID),
which means this would be quite a bit less than trivial as far as internal
representation/implementation goes.  I'm not sure if there would be
grammar issues, either.
        regards, tom lane



pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: [sqlsmith] Failed to generate plan on lateral subqueries
Next
From: Tom Lane
Date:
Subject: Re: Fwd: [GENERAL] pgxs/config/missing is... missing