[odb-users] ODB and aggregate functions

[Nicolas ALBEZA]

It would fit perfectly.

Regards,

2011/8/19 Boris Kolpackov <boris at codesynthesis.com>

> Hi Nicolas,
>
> Nicolas ALBEZA <n.albeza at gmail.com> writes:
>
> > I'm looking for a way to use aggregate (group-by) functions with ODB, to
> use
> > in simple queries, such as "SELECT AVG(field) from table where ...".
> >
> > It seems that ODB doesnt allow such things, so i guess i'll have to use
> the
> > low-level and db specific functions to reach my goal.
> > Is there any examples or documentation about that ? (I'm using a mysql
> DB).
>
> I think the 'view' feature that is still in development will allow you
> to achieve this pretty easily. I have described it a couple of days ago
> in this post:
>
> http://www.codesynthesis.com/pipermail/odb-users/2011-August/000239.html
>
> Do you think it will work for your use case?
>
> Boris
>



-- 
ALBEZA "Pause" Nicolas