On Mon, Mar 16, 2009 at 11:07 AM, koranthala <koranth...@gmail.com> wrote:
> > Hi, > I downloaded Django 1.1 due to aggregation support. > But I am facing one issue which I cannot seem to overcome. > I have two fields which represents two different times. > I want to get the sum of difference of times - and I am unable to > do so. > Basically, I want to do as follows: > SELECT SUM (time2 - time1) FROM _TABLE_ WHERE __XXX___ > > I tried 2 options: > 1. self.filter( XXX).aggregate(diff=Sum('time2 - time1')) > 2. self.filter (XXX).aggregate(t2=Sum('time2'), t1= Sum('time1')) - so > that I can do t2 - t1 later. > > Both is not supported in Django. I have raw SQL code in model > Manager for the same. I thought using Django Aggregation is better. Is > such operations going to be supported in Django 1.1 ? > > Regards > Koran > > > > > > Right now that isn't possible, is there any reason you couldn't just bring the seperate SUMs into python and do the subtraction there, I realize it isn't quite as clean but the overhead should be minimal? Alex -- "I disapprove of what you say, but I will defend to the death your right to say it." --Voltaire "The people's good is the highest law."--Cicero --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Django users" group. To post to this group, send email to django-users@googlegroups.com To unsubscribe from this group, send email to django-users+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/django-users?hl=en -~----------~----~----~----~------~----~------~--~---