Andrew Gierth <andrew(at)tao11(dot)riddles(dot)org(dot)uk> writes:
> select * from test1 full join test2 using (a,b) where b=1;
> 8.3.1 and CVS HEAD produce a plan in which the b=1 condition is pushed
> down into each side of the join, but 8.3.6 and 8.3.7 do not.
It does what you're expecting in 8.3 branch tip.
We're really overdue for a set of back-branch update releases :-(
regards, tom lane
In response to
pgsql-hackers by date
|Next:||From: Robert Haas||Date: 2009-07-21 17:10:57|
|Subject: Re: Index-only-scans, indexam API changes|
|Previous:||From: Alexey Klyukin||Date: 2009-07-21 16:47:38|
|Subject: Re: errcontext support in PL/Perl|