[Zope-DB] ZSQL, sum() and you

[Mitch Pirtle]

Hi folks,

There's something I've been wanting to ask, but after lurking around
I've noticed I'm the only one with this problem.  That occasion usually
precedes an embarassing episode -;^>=

Imagine, if you will, a ZSQL method called dbGetEmp containing "select *
from emp"; and want to also retrieve sum(salary).  This is with tables
in MySQL.  For the life of me, I cannot find any summing features in
Zope - do I gotta do this in Python just to get a total on one column?

Sure, I can do it with two separate queries, but argh that's just plain
sick.

Apologies in advance for missing the obvious, as I know this is taken
care of somewhere...