Re: postgres FROM clause problem (GROUP BY subquestion)

Поиск
Список
Период
Сортировка
От Paolo Tavalazzi
Тема Re: postgres FROM clause problem (GROUP BY subquestion)
Дата
Msg-id 200403110943.58074.ptavalazzi@charta.it
обсуждение исходный текст
Ответ на Re: postgres FROM clause problem (GROUP BY subquestion)  (Bruno Wolff III <bruno@wolff.to>)
Ответы Re: postgres FROM clause problem (GROUP BY subquestion)
Список 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 по дате отправления:

Предыдущее
От: "Bobbie van der Westhuizen"
Дата:
Сообщение: Re: updates (postgreSQL) very slow
Следующее
От: Csaba Nagy
Дата:
Сообщение: Re: More Deadlock Detection on Insert