Re: [RDBO] One-to-many and aggregates

2007-10-29 Thread Arshavir Grigorian
On 10/25/07, John Siracusa <[EMAIL PROTECTED]> wrote: > On 10/25/07, Arshavir Grigorian <[EMAIL PROTECTED]> wrote: > > I found an old post on the subject > > (http://osdir.com/ml/lang.perl.modules.dbi.rose-db-object/2006-08/msg00077.html) > > but am not sure how to implement this in a one-to-many c

Re: [RDBO] One-to-many and aggregates

2007-10-25 Thread John Siracusa
On 10/25/07, Arshavir Grigorian <[EMAIL PROTECTED]> wrote: > I found an old post on the subject > (http://osdir.com/ml/lang.perl.modules.dbi.rose-db-object/2006-08/msg00077.html) > but am not sure how to implement this in a one-to-many context. The approach is the same, just the details are differ

[RDBO] One-to-many and aggregates

2007-10-24 Thread Arshavir Grigorian
Hi, I have two tables t1 and t2 linked through a one-to-many relationship. Each record in t1 has 0 or more corresponding records in t2. Given a My::T1 object, I would like to get an average on a column in t2 for all rows corresponding to the My::T1 row. t1 (id, name) --- 1, 'm