Re: postgres FROM clause problem (GROUP BY subquestion)

From: Bruno Wolff III <bruno(at)wolff(dot)to>
To: Paolo Tavalazzi <ptavalazzi(at)charta(dot)it>
Cc: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, pgsql-general(at)postgresql(dot)org
Subject: Re: postgres FROM clause problem (GROUP BY subquestion)
Date: 2004-03-10 18:12:47
Message-ID: 20040310181247.GA6195@wolff.to
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Wed, Mar 10, 2004 at 18:33:41 +0100,
Paolo Tavalazzi <ptavalazzi(at)charta(dot)it> wrote:
>
> I don't know what to make, help me please!
>
> Another question, in 7.4 GROUP BY clause not guarantee the ordering of result.
> Can I desable the new group by algorithm to maintain the coherence whit the programs that I have in production with pg_7.3

GROUP BY never guarenteed an order. That this happened in 7.3 was an
implementation detail. If you want a specific order you need to use an
ORDER BY clause.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2004-03-10 18:40:40 Re: postgres FROM clause problem
Previous Message Paolo Tavalazzi 2004-03-10 17:33:41 Re: postgres FROM clause problem