Hi again,
I figured out why this didn't work for me and I hope by posting this I
will save somebody some hairs. palewire's comment on
http://code.djangoproject.com/ticket/10302 described the same problem
that I had. The SQL that's generated includes, apart from the "GROUP BY
month" clause, also a GROUP BY date_time which defeats the purpose and
explains why I never get any grouping done.
However, it turns out that my model as an ordering Meta which results in
all ordering fields to be explicitly included in any GROUP BY. All I had
to do was to add a .order_by('month') to my query and it worked as expected.
The documentation doesn't properly describe this gotcha but now you know.
Gunther
--
You received this message because you are subscribed to the Google Groups "Django
users" group.
To post to this group, send email to django-us...@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.
