Always one row with group by / agregate

Alain TESIO <tesio@easynet.fr>

From: "Alain TESIO" <tesio@easynet.fr>
To: "PGSQL Bugs" <pgsql-bugs@postgresql.org>
Date: 1999-12-27T06:12:45Z
Lists: 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