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  (Tom Lane <tgl@sss.pgh.pa.us>)
Список 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 по дате отправления:

Предыдущее
От:
Дата:
Сообщение: ǧìûÖ®Äê´ó·îËÍ Ë«Ï²ÁÙÃŵ½Íõ³¯
Следующее
От: "Alain TESIO"
Дата:
Сообщение: Equal test on strings doesn't ignore trailing spaces if the function 'lower' is applied