The following bug has been logged online: Bug reference: 4926 Logged by: Roman Kononov Email address: kono...@ftml.net PostgreSQL version: 8.4.0 Operating system: Linux x86_64 Description: too few pathkeys for mergeclauses Details:
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 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)=y; i | x | y ---+---+--- (0 rows) I think, the first query should be handled the same way second is. -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs
