From: patrick <patrick+pgsql@boxsoft.com>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: Stephan Szabo <sszabo@megazone23.bigpanda.com>
Cc: pgsql-sql@postgresql.org
Subject: Re: sub-select trouble: wrong SQL or PostgreSQL issue?
Date: Thu, 24 Oct 2002 02:15:44 -0700
Message-ID: <20021024021544.G3699@3eye.boxsoft.com> (raw)
In-Reply-To: <8629.1035430081@sss.pgh.pa.us>
References: <20021023195621.F13686-100000@megazone23.bigpanda.com>
<8629.1035430081@sss.pgh.pa.us>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: patrick+pgsql@boxsoft.com, tgl@sss.pgh.pa.us, sszabo@megazone23.bigpanda.com
Subject: Re: sub-select trouble: wrong SQL or PostgreSQL issue?
In-Reply-To: <20021024021544.G3699@3eye.boxsoft.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox