On Thu, Jul 16, 2009 at 9:07 PM, Roman Kononov<kononov(at)ftml(dot)net> wrote:
>
> test=# create table junk(i int);
> CREATE TABLE
> test=# select * from junk left outer join (select coalesce(i,1) as x,
> coalesce(i,2) as y from junk) t on coalesce(i,3)=x and coalesce(i,4)=y and
> coalesce(i,5)=x;
> ERROR: too few pathkeys for mergeclauses
Thanks for the bug report. That's definitely not supposed to be
happening. It's always nice when it's easy to reproduce the problem
like this.
--
greg
http://mit.edu/~gsstark/resume.pdf