Postgres Pro
Downloads
Home   >   mailing lists

Re: Allowing NOT IN to use ANTI joins - Mailing list pgsql-hackers

From Jeevan Chalke
Subject Re: Allowing NOT IN to use ANTI joins
Date
Msg-id CAM2+6=WasbauEfKMDNFXPchGj-q4s0QwaWG-rs+2F9bjQ4CHUg@mail.gmail.com
Whole thread Raw
In response to Re: Allowing NOT IN to use ANTI joins  (David Rowley <dgrowleyml@gmail.com>)
List pgsql-hackers
Tree view
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

pgsql-hackers by date:

Previous
From: Jov
Date:
Subject: Re: change alter user to be a true alias for alter role
Next
From: Pavel Stehule
Date:
Subject: Re: psql: show only failed queries