Re: Joins on over 10 tables returns unreliable results

pgsql-bugs@postgresql.org writes:
> Running Postgres version 7.01 on Redhat linux 6.2.  When joining on
> more than 10 tables not all of the expected results are returned.

Do you get a query plan involving mergejoins for these queries?
If so it's probably fixed for 7.0.3, please try that as soon as
it's out...

            regards, tom lane