hello,
this works with sqlite:
AppModel.objects.extra(select={'year':"django_date_trunc('year', \"date
\")"}).values('year').order_by().annotate(total = Count('id'))
i assume that for postgresql i would have to use date_trunc function.
is there a portable way to do this?
thanks
konstantin
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
