On Tue, Feb 10, 2009 at 8:09 PM, Jonah H. Harris <[email protected]>wrote:
> On Tue, Feb 10, 2009 at 3:10 PM, Tom Lane <[email protected]> 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
