Skip site navigation (1) Skip section navigation (2)

Re: sub-select trouble: wrong SQL or PostgreSQL issue?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Stephan Szabo <sszabo(at)megazone23(dot)bigpanda(dot)com>
Cc: patrick <patrick+pgsql(at)boxsoft(dot)com>, pgsql-sql(at)postgresql(dot)org
Subject: Re: sub-select trouble: wrong SQL or PostgreSQL issue?
Date: 2002-10-24 03:28:01
Message-ID: 8629.1035430081@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-sql
>> 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

In response to

Responses

pgsql-sql by date

Next:From: Ludwig LimDate: 2002-10-24 04:10:32
Subject: Simulating a SELECT..FOR UPDATE to LOCK and SELECT statement
Previous:From: Stephan SzaboDate: 2002-10-24 02:59:09
Subject: Re: sub-select trouble: wrong SQL or PostgreSQL issue?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group