On 2/6/07, Bram - Smartelectronix <[EMAIL PROTECTED]> wrote: > > > It doesn't... I need a "group by" which doesn't seem possible in any way > in django.
It is possible, in a number of ways: 1) Get a connection.cursor(), and write the full SQL manually 2) Use the extra() clause on a queryset 3) Write a custom Q objects. Options 2 and 3 don't have explicit support for GROUP BY clauses; however, the SQL is rolled out in a reliable and consistent way, so you can piggyback a GROUP BY onto the back of another clause (IIRC, the where clause is usually a good candidate). Yours, Russ Magee %-) --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Django users" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/django-users?hl=en -~----------~----~----~----~------~----~------~--~---
