Try this:
R.objects.values('type').aggregate(Count('type'))
On Fri, Mar 6, 2009 at 10:12 PM, kbs <kout...@gmail.com> wrote:
>
> Hello,
>
> I got a model with a type field
>
> <code>
> class R(mode):
> type = CharField(max_length=100)
> </code>
>
> Here is what im trying to do using sql notation:
>
> <code>
> SELECT typ,count(*) FROM R GROUP BY type
> </code>
>
> The following
> <code>
> R.objects.aggregate(Count('type'))
> </code>
>
> returns the same result as
>
> <code>
> SELECT count(*) R
> </code>
>
> is it possible with a one liner using django qs syntax?
>
> thanks
> >
>
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
