[jifty-devel] Queries using GROUP BY and aggregate functions

Jesse Vincent jesse at bestpractical.com
Sat Jul 7 14:42:01 EDT 2007


On Jul 7, 2007, at 2:35 PM, Andrew Sterling Hanenkamp wrote:

> That's what I thought, which brings me back to: how do I get the
> result of an aggregate function like MAX or SUM when I'm not
> interested in any individual records--as in, in a similar way to how
> we can grab the COUNT of rows?
>
> I can just perform the query using SQL on the DBI for now, but JDBI
> could probably add a shortcut for this pretty easily if one doesn't
> already exist.

Better shortcuts are needed. Our current "method" involves trolling  
the returned datastructure.  Whyat would a good API look like?
-------------- next part --------------
A non-text attachment was scrubbed...
Name: PGP.sig
Type: application/pgp-signature
Size: 186 bytes
Desc: This is a digitally signed message part
Url : http://lists.bestpractical.com/pipermail/jifty-devel/attachments/20070707/bd84129c/PGP.pgp


More information about the jifty-devel mailing list