This is not possible because the database does not support it. Lists are not even stored as lists, they are stored as strings.
On Thursday, 17 May 2012 16:13:50 UTC-5, Richard wrote: > > Hello, > > I don't know if this has be fixed since 1.99.4, but I can't aggregates a > table if a list:reference field is present in the requested fields. > > db().select(db.tab1.f2.sum()/db.tab1.f2.count(), > db.tab1.f3_list-reference.sum(), groupby=db.tab1.f4) give error... Ok, here > I think that ok since the list-reference field maybe should not be consider > a normal field and maybe an other set of function should be developped?! > > I have 3 records : > list-reference fields : [1,2,3], [4,5,6], [7] > > I mean : > .sum_list_reference() : Should return [[1,2,3], [4,5,6], [7]] > .avg_list_reference() : Should return : [1,2,3,4,5,6,7] > .count_list_reference() : Should count the number of list-reference field > in this case 3 > etc. > > What do you think? > > Richard > > > >
