Re: [HACKERS] Wishlist for next version: group by clause

Поиск
Список
Период
Сортировка
От David Hartwig
Тема Re: [HACKERS] Wishlist for next version: group by clause
Дата
Msg-id 3586D537.57ABC1DF@insightdist.com
обсуждение исходный текст
Ответ на Re: [HACKERS] Wishlist for next version: group by clause  (De Clarke <de@ucolick.org>)
Ответы group by : syntactic example (sybase)  (De Clarke <de@ucolick.org>)
Список pgsql-hackers
Do you mean in a select statement?   Such as:

    SELECT func(date) as month, count(*) FROM foo GROUP BY month;

Or even:

    SELECT count(*) FROM foo GROUP BY func(date);

The first is supported.   The second would require some changes to the parser.

De Clarke wrote:

> I didn't realize PG could not do
>
>         group by [function on column]
>
> Ouch!
>




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

Предыдущее
От: Brett McCormick
Дата:
Сообщение: Re: [HACKERS] seq scan only when function not in subquery (bug?)
Следующее
От: De Clarke
Дата:
Сообщение: group by : syntactic example (sybase)