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

From Paolo Tavalazzi
Subject Re: postgres FROM clause problem (GROUP BY subquestion)
Date
Msg-id 200403110943.58074.ptavalazzi@charta.it
Whole thread Raw
In response to Re: postgres FROM clause problem (GROUP BY subquestion)  (Bruno Wolff III <bruno@wolff.to>)
Responses Re: postgres FROM clause problem (GROUP BY subquestion)
List pgsql-general
Alle 19:12, mercoledì 10 marzo 2004, hai scritto:
> 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.


Seeing that GROUP BY in 7.3 required sorting the input data to bring group members together,
this guaranteed to me also the order of the attributes in GROUP BY clause.

pgsql-general by date:

Previous
From: "Bobbie van der Westhuizen"
Date:
Subject: Re: updates (postgreSQL) very slow
Next
From: Csaba Nagy
Date:
Subject: Re: More Deadlock Detection on Insert