Re: [BUGS] Always one row with group by / agregate

Tom Lane <tgl@sss.pgh.pa.us>

From: Tom Lane <tgl@sss.pgh.pa.us>
To: "Alain TESIO" <tesio@easynet.fr>
Cc: "PGSQL Bugs" <pgsql-bugs@postgreSQL.org>
Date: 1999-12-27T15:52:43Z
Lists: pgsql-bugs
"Alain TESIO" <tesio@easynet.fr> writes:
> dip=> select x,min(y) from t group by x;
> x|min
> -+---
>  |
> (1 row)

Yup, that's a bug --- with GROUP BY, no rows in should yield no groups
and hence no rows out.  It's fixed for the next release.

			regards, tom lane