On Fri, Nov 20, 2009 at 2:47 AM, Andy McKay <[email protected]> wrote: > On 09-11-19 3:36 PM, Benjamin Wolf wrote: ... > > Try using values in the filter eg: > > Disposal.objects.values("mydate").filter(mydate__year__gte=2008).distinct() > > The problem is the default django query selects all the fields, messing > up the distinct part. >
If you happen to be in PostgreSQL, might you be able to put "DISTINCT ON" in an .extra() where? Of course, you have to know what the ORM is calling the columns. Bill -- 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=.
