On Thu, Jul 16, 2009 at 9:07 PM, Roman Kononov<kono...@ftml.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 -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs