>> 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,
If so, the fix is in 7.2.*.
regards, tom lane
In response to
pgsql-sql by date
|Next:||From: Ludwig Lim||Date: 2002-10-24 04:10:32|
|Subject: Simulating a SELECT..FOR UPDATE to LOCK and SELECT statement|
|Previous:||From: Stephan Szabo||Date: 2002-10-24 02:59:09|
|Subject: Re: sub-select trouble: wrong SQL or PostgreSQL issue?|