Always one row with group by / agregate

Поиск
Список
Период
Сортировка
От Alain TESIO
Тема Always one row with group by / agregate
Дата
Msg-id 00c801bf5032$82496c20$df5f72c3@atesio
обсуждение исходный текст
Ответы Re: [BUGS] Always one row with group by / agregate
Список pgsql-bugs
dip=> create table t ( x int , y int );
CREATE
dip=> select x,min(y) from t group by x;
x|min
-+---
 |
(1 row)


select min(y) should return one row with a null value, but it's
expected. I thought that the first part of the job was to process
the group by and then the select on each group, but it doesn't
seem to be the case.

Alain




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