Re: possible bug with group by?

Поиск
Список
Период
Сортировка
Искать
От
Tom Lane
Тема
Re: possible bug with group by?
Дата
в 23:00:38
Msg-id
19251.959223598@sss.pgh.pa.us
Ответ на
Список
Дерево обсуждения
Re: possible bug with group by? Joseph Shraibman <jks@selectacast.net>
Re: possible bug with group by? Tom Lane <tgl@sss.pgh.pa.us>
Joseph Shraibman  writes:
> But why would group by need to sort it?  To insert it into a tree to
> make lookups of distinct values faster?

No, to bring identical values together.  GROUP BY and DISTINCT are both
implemented as basically a "sort | uniq" pipeline.
		regards, tom lane

В списке pgsql-sql по дате отправления
От: Joseph Shraibman
Дата:
От: Tom Lane
Дата:
Сообщение: Re: Use of index in 7.0 vs 6.5
FAQ