From: Dave Rolsky <autarch@ur...> - 2002-09-20 16:42:10
On Fri, 20 Sep 2002, Christophe KLOPP wrote:
> Is it possible to use the SQL 'group by' in a select statement with
> alzabo? And if it is, how?
Sure, here's an example:
my $cursor =
( select => [ COUNT( $foo_table->column_x ), $foo_table->user_id ],
group_by => $foo_table->user_id,
Basically, it works more or less like you'd expect. The cursor object
returned here will return a two element array of data every time you call
next() on it.
we await the New Sun