Horton

Re: Join Problem in Postgres 7.0.2

Tom Lane <tgl@sss.pgh.pa.us>

View thread
From: Tom Lane <tgl@sss.pgh.pa.us>
To: xudien@hotmail.com, pgsql-bugs@postgresql.org
Date: 2000-11-29T16:36:15Z
Lists: pgsql-bugs 
pgsql-bugs@postgresql.org writes:
> I get into a situation, in which I think it is a bug in either psql or
> the database.  I have experienced that when I ran two queries in psql,
> which are equivalent, I received two different results

Does EXPLAIN show that the failing query has a Merge Join directly
underneath another Merge Join?  If so, this is a known bug.  It's
fixed in 7.0.3.

			regards, tom lane