Thanks, patch indeed fixes my original breaking query.
-Matt
-----Original Message-----
From: Tom Lane [mailto:tgl(at)sss(dot)pgh(dot)pa(dot)us]
Matthew Gabeler-Lee <mgabelerlee(at)zycos(dot)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.