Re: full join qualifications on 8.3.1 vs. 8.3.6

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Andrew Gierth <andrew(at)tao11(dot)riddles(dot)org(dot)uk>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: full join qualifications on 8.3.1 vs. 8.3.6
Date: 2009-07-21 16:58:11
Message-ID: 15213.1248195491@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

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.

http://archives.postgresql.org/pgsql-committers/2009-04/msg00204.php

We're really overdue for a set of back-branch update releases :-(

regards, tom lane

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Robert Haas 2009-07-21 17:10:57 Re: Index-only-scans, indexam API changes
Previous Message Alexey Klyukin 2009-07-21 16:47:38 Re: errcontext support in PL/Perl