On Tue, Feb 10, 2009 at 8:09 PM, Jonah H. Harris <jonah.har...@gmail.com>wrote:
> On Tue, Feb 10, 2009 at 3:10 PM, Tom Lane <t...@sss.pgh.pa.us> wrote: > >> I wrote (in response to Kevin Grittner's recent issues): >> > Reflecting on this further, I suspect there are also some bugs in the >> > planner's rules about when semi/antijoins can commute with other joins; >> >> After doing some math I've concluded this is in fact the case. Anyone >> want to check my work? > > > FWIW, the logic looks correct to me. Cripes! I just had an idea and it looks like the buggers beat me to it :( http://www.google.com/patents?id=4bqBAAAAEBAJ&dq=null+aware+anti-join -- Jonah H. Harris, Senior DBA myYearbook.com