
	>druid=> SELECT client_id, SUM(tramount) FROM acctrans GROUP BY
>client_id;
	>client_id|sum
	>---------+---
	>         |   
	>(1 row)
	>
	>If there are no rows in the table then shouldn't the result be no
rows
	>when GROUP BY is used?  Further, What about this?

Yes, should return no rows. seems like a fix is needed here :-(

Andreas


Wed, 13 Jan 1999 09:07:08 +0100
Zeugswetter Andreas IZ5 <Andreas.Zeugswetter@telecom.at>
AW: [HACKERS] SUM() and GROUP BY