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

From: Stephan Szabo <sszabo(at)megazone23(dot)bigpanda(dot)com>
To: patrick <patrick+pgsql(at)boxsoft(dot)com>
Cc: <pgsql-sql(at)postgresql(dot)org>
Subject: Re: sub-select trouble: wrong SQL or PostgreSQL issue?
Date: 2002-10-24 02:59:09
Message-ID: 20021023195621.F13686-100000@megazone23.bigpanda.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql


> Strangely, this is the result we were expecting from our
> original query!
>
> Is it possible that the sub-selects are somehow
> affecting the result sets?
>
>
> Seen on:
> % postmaster --version
> postmaster (PostgreSQL) 7.1.3
>
> and
>
> % postmaster --version
> postmaster (PostgreSQL) 7.1.2

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.

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Tom Lane 2002-10-24 03:28:01 Re: sub-select trouble: wrong SQL or PostgreSQL issue?
Previous Message patrick 2002-10-24 02:44:14 sub-select trouble: wrong SQL or PostgreSQL issue?