AW: [HACKERS] SUM() and GROUP BY

From: Zeugswetter Andreas IZ5 <Andreas(dot)Zeugswetter(at)telecom(dot)at>
To: pgsql-hackers(at)postgreSQL(dot)org
Subject: AW: [HACKERS] SUM() and GROUP BY
Date: 1999-01-13 08:07:08
Message-ID: 219F68D65015D011A8E000006F8590C60267B2D3@sdexcsrv1.sd.spardat.at
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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 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

Browse pgsql-hackers by date

  From Date Subject
Next Message Massimo Dal Zotto 1999-01-13 09:23:00 Re: [HACKERS] postgres and year 2000
Previous Message Bruce Momjian 1999-01-13 07:21:08 Re: [HACKERS] Re: EXCEPT/INTERSECT for v6.4