Re: SELECT, GROUP BY, and aggregates

Поиск
Список
Период
Сортировка
От Bill Moran
Тема Re: SELECT, GROUP BY, and aggregates
Дата
Msg-id 20150213132630.00ca5b669114bc903736d5f7@potentialtech.com
обсуждение исходный текст
Ответ на Re: SELECT, GROUP BY, and aggregates  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: SELECT, GROUP BY, and aggregates  (Jeff Janes <jeff.janes@gmail.com>)
Список pgsql-general
> Ryan Delaney <ryan.delaney@gmail.com> writes:
> > Why couldn't an RDBMS such as postgres interpret a SELECT that omits the GROUP
> > BY as implicitly grouping by all the columns that aren't part of an aggregate?

I'm Mr. Curious today ...

Why would you think that such a thing is necessary or desirable? Simply add the
columns to the GROUP BY clause and make the request unambiguous.

--
Bill Moran


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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Contrib build fault for pgdg postgres 9.2 at debian 6 (squeeze)
Следующее
От: Jeff Janes
Дата:
Сообщение: Re: SELECT, GROUP BY, and aggregates