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 --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---