Thanks, patch indeed fixes my original breaking query.
-Matt
-----Original Message-----
From: Tom Lane [mailto:tgl@sss.pgh.pa.us]
Matthew Gabeler-Lee <mgabelerlee@zycos.com> writes:
> -- triggers bug
> select * from (select t1.*, (select t2.c from t2 limit 1) as v from t1)
t1v
> natural left join t3;
Excellent, thank you for the test case.
I've applied the attached patch to prevent this problem.