AW: [HACKERS] SUM() and GROUP BY - Mailing list pgsql-hackers

From Zeugswetter Andreas IZ5
Subject AW: [HACKERS] SUM() and GROUP BY
Date
Msg-id 219F68D65015D011A8E000006F8590C60267B2D3@sdexcsrv1.sd.spardat.at
Whole thread Raw
List pgsql-hackers
>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
resultbe no
 
rows>when GROUP BY is used?  Further, What about this?

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

Andreas



pgsql-hackers by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: [HACKERS] Re: EXCEPT/INTERSECT for v6.4
Next
From: jwieck@debis.com (Jan Wieck)
Date:
Subject: Re: [HACKERS] CONSTRAINTS...