Simon Riggs <simon@xxxxxxxxxxxxxxx> 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 -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance