Postgres Pro
Downloads
Home   >   mailing lists

Re: Execute query with EXCEPT, INTERSECT as anti-join, join? - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Execute query with EXCEPT, INTERSECT as anti-join, join?
Date
Msg-id 15498.1384176883@sss.pgh.pa.us
Whole thread Raw
In response to Execute query with EXCEPT, INTERSECT as anti-join, join?  ("Colin 't Hart" <colinthart@gmail.com>)
Responses Re: Execute query with EXCEPT, INTERSECT as anti-join, join?  ("Colin 't Hart" <colin@sharpheart.org>)
List pgsql-hackers
Tree view 
"Colin 't Hart" <colinthart@gmail.com> writes:
> I can't get Postgresql to execute a query with EXCEPT (or INTERSECT)
> as an anti-join (or join).

> Is this even possible?

No, and it probably won't ever be, since the semantics aren't the same.
EXCEPT/INTERSECT imply duplicate elimination.
        regards, tom lane

pgsql-hackers by date:

Previous
From: Rohit Goyal
Date:
Subject: Re: Fwd: Test of Algorithm || Indexing Scheme
Next
From: Magnus Hagander
Date:
Subject: Re: streaming header too small