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: pgsql-general(at)postgresql(dot)org
Subject: Re: postgres FROM clause problem (GROUP BY subquestion)
Date: 2004-03-11 19:14:35
Message-ID: 20040311191435.GA25007@wolff.to
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Thu, Mar 11, 2004 at 09:43:57 +0100,
Paolo Tavalazzi <ptavalazzi(at)charta(dot)it> wrote:
> Alle 19:12, mercoledì 10 marzo 2004, hai scritto:
> > 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.
>
>
> 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.

This might be a language difference. You weren't guarenteed (or promised)
that the output would be sorted. It just happened that way because of how
the database implemented the group by. By reading the source code for
that version it would be possible to determine that the output would
always be sorted. However, that could change at any upgrade or if you
switched databases.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message FernAndo 2004-03-11 20:23:01 archives insert + Delphi
Previous Message Tom Lane 2004-03-11 18:32:31 Re: "make check" fails for 7.4.2 checked out from CVS