Hi,
> With further testing I noticed that the patch was not allowing ANTI joins > in cases like this: > > explain select * from a where id not in(select x from b natural join c); > > > I too found this with natural joins and was about to report that. But its good that you found that and fixed it as well. I have reviewed this and didn't find any issues as such. So marking it "Ready for Committer". Thanks -- Jeevan B Chalke Principal Software Engineer, Product Development EnterpriseDB Corporation The Enterprise PostgreSQL Company