Re: Aggregate using extra() fields

2009-09-21 Thread Kathleen Benitez
s <mrts.py...@gmail.com> wrote: > On Sep 16, 11:30 pm, Kathleen Benitez <kathleen.beni...@gmail.com> > wrote: > > > I am attempting to evaluate some generalization schemes using Django. > > In particular, I'd like to create a new field (generalized race), and > &

Aggregate using extra() fields

2009-09-16 Thread Kathleen Benitez
I am attempting to evaluate some generalization schemes using Django. In particular, I'd like to create a new field (generalized race), and then find a total population using the values() function as follows: 1 r = Records.objects 2 r = r.extra(select={'generalized_race: "CASE race WHEN