Ryan Wallace <rywall(at)gmail(dot)com> writes:
> Query returns incorrect results when executed on PostgreSQL 8.4.0. The
> same query was executed successfully on PostgreSQL 8.3.7.
There have been some fixes in the semijoin-planning code since 8.4.0.
Would you try your test case against a CVS pull or nightly snapshot?
regards, tom lane