Postgres Pro
Downloads
Home   >   mailing lists

Re: postgres FROM clause problem (GROUP BY subquestion) - Mailing list pgsql-general

From Bruno Wolff III
Subject Re: postgres FROM clause problem (GROUP BY subquestion)
Date
Msg-id 20040310181247.GA6195@wolff.to
Whole thread Raw
In response to Re: postgres FROM clause problem  (Paolo Tavalazzi <ptavalazzi@charta.it>)
Responses Re: postgres FROM clause problem (GROUP BY subquestion)
List pgsql-general
Tree view 
On Wed, Mar 10, 2004 at 18:33:41 +0100,
  Paolo Tavalazzi <ptavalazzi@charta.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.

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: postgres FROM clause problem
Next
From: Randall Skelton
Date:
Subject: returning row numbers in select