On retrieve only? Richard
On Thu, May 17, 2012 at 7:03 PM, Massimo Di Pierro < [email protected]> wrote: > 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 >> >> >> >>
