Re: 'GROUP BY' / 'DISTINCT' interaction bug?

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: 'GROUP BY' / 'DISTINCT' interaction bug?
Дата
Msg-id 6345.965663978@sss.pgh.pa.us
обсуждение исходный текст
Ответ на 'GROUP BY' / 'DISTINCT' interaction bug?  ("Mark Hollomon" <mhh@nortelnetworks.com>)
Список pgsql-hackers
"Mark Hollomon" <mhh@nortelnetworks.com> writes:
> select distinct on (c, i) c, count(i) from t group by c;
> ERROR:  Attribute t.i must be GROUPed or used in an aggregate function

Why do you think that's a bug?  The DISTINCT clause requires use of
the ungrouped value of i, doesn't it?
        regards, tom lane


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