Always one row with group by / agregate - Mailing list pgsql-bugs

From Alain TESIO
Subject Always one row with group by / agregate
Date
Msg-id 00c801bf5032$82496c20$df5f72c3@atesio
Whole thread Raw
Responses Re: [BUGS] Always one row with group by / agregate
List 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 by date:

Previous
From:
Date:
Subject: ǧìûÖ®Äê´ó·îËÍ Ë«Ï²ÁÙÃŵ½Íõ³¯
Next
From: "Alain TESIO"
Date:
Subject: Equal test on strings doesn't ignore trailing spaces if the function 'lower' is applied