Re: Optimization of unnecessary GROUP BY columns

Поиск
Список
Период
Сортировка
От Martijn van Oosterhout
Тема Re: Optimization of unnecessary GROUP BY columns
Дата
Msg-id 20061226171352.GE8412@svana.org
обсуждение исходный текст
Ответ на Optimization of unnecessary GROUP BY columns  (Kevin Murphy <murphy@genome.chop.edu>)
Ответы Re: Optimization of unnecessary GROUP BY columns  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-general
On Tue, Dec 26, 2006 at 12:08:04PM -0500, Kevin Murphy wrote:
> When columns are required in a GROUP BY clause even though some of them
> are fully dependent on others, is there any plan for making it possible
> to do the GROUP BY only on the necessary columns?  The 8.X documentation
> made me curious:

Recent SQL standards require it, so it's likely to be implemented at
some point.

Havn't seen any patches in that direction though...

Have a nice day,
--
Martijn van Oosterhout   <kleptog@svana.org>   http://svana.org/kleptog/
> From each according to his ability. To each according to his ability to litigate.

Вложения

В списке pgsql-general по дате отправления:

Предыдущее
От: Kevin Murphy
Дата:
Сообщение: Optimization of unnecessary GROUP BY columns
Следующее
От: "Melvin Davidson"
Дата:
Сообщение: Functions to obtain group members- PostgreSQL prior to 8.1