Simon Riggs <simon(at)2ndQuadrant(dot)com> writes:
> On Fri, 2009-04-03 at 10:04 -0400, Tom Lane wrote:
>> I don't actually believe that a standard merge join algorithm will work
>> with an intransitive join condition ...
> I think it's a common enough problem that having a non-standard join
> algorithm written for that case would be interesting indeed.
Sounds like a great PhD thesis topic.
regards, tom lane