Date: Thu, 24 Oct 2002 02:15:44 -0700
From: patrick <patrick+pgsql@boxsoft.com>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: Stephan Szabo <sszabo@megazone23.bigpanda.com>,
	pgsql-sql@postgresql.org
Subject: Re: sub-select trouble: wrong SQL or PostgreSQL issue?
Message-ID: <20021024021544.G3699@3eye.boxsoft.com>
References: <20021023195621.F13686-100000@megazone23.bigpanda.com>
	<8629.1035430081@sss.pgh.pa.us>
Mime-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
User-Agent: Mutt/1.2.5.1i
In-Reply-To: <8629.1035430081@sss.pgh.pa.us>;
	from tgl@sss.pgh.pa.us on Wed, Oct 23, 2002 at 11:28:01PM -0400


Thank you both for your prompt responses.  Bug #526 (as Tom
pointed out) does look very similar to my problem.

I'll attempt to upgrade my development PostgreSQL and
eventually my production servers if all goes well.

Thanks again,


On Wed, Oct 23, 2002 at 11:28:01PM -0400, Tom Lane wrote:
> >> Is it possible that the sub-selects are somehow
> >> affecting the result sets?
> 
> > I think you want to upgrade, 7.3beta at least gives your
> > expected output on all the queries when I tried it.  I don't
> > currently have a 7.2.* system to test on here to try it
> > with that series.
> 
> I think this may be the same problem as bug #526,
> http://archives.postgresql.org/pgsql-bugs/2001-11/msg00168.php
> If so, the fix is in 7.2.*.
> 
> 			regards, tom lane

sidster
--
They who would sacrifice freedom for security will have neither.
   -Ben Franklin