Stephan Szabo <sszabo(at)megazone23(dot)bigpanda(dot)com> writes:
> Actually, hadn't we figured that pushing to the left side of except was
It's not safe for EXCEPT ALL (you might get the wrong number of
duplicates out), and I'm not entirely convinced about EXCEPT.
Also, the point of pushing down is to speed up the subqueries, so I'm
not sure there's much win if you can't push to both sides.
All in all I'd just as soon leave the EXCEPT case alone.
regards, tom lane
In response to
pgsql-patches by date
|Next:||From: Robert Treat||Date: 2002-08-29 16:09:58|
|Subject: Re: [HACKERS] Proposed GUC Variable|
|Previous:||From: John Gray||Date: 2002-08-29 15:51:10|
|Subject: Re: Visibility regression test|