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