Обсуждение: AW: [HACKERS] SUM() and GROUP BY

Поиск
Список
Период
Сортировка

AW: [HACKERS] SUM() and GROUP BY

От
Zeugswetter Andreas IZ5
Дата:
>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