I've tried various permuations of filters and approaches in
attempting to get unique/distinct results on a django query
with postgres data to no avail. Using distinct() has no effect
on queries in the following examples...

qset        = (Q(title__icontains='MOBY DICK'))
results1 = books.objects.filter(qset).distinct()

I've also tried the following where ItemNo is an integer.

X = books.objects.order_by('ItemNo').filter(qset).distinct('ItemNo')

Y = X.order_by('ItemNo').distinct('ItemNo')

.distinct() in the above instances has no effect, i get
a list of books with the same author, title, itemno. Even
though they are different editions and reflected in the data
by separate records its not possible to simply get a
preliminary distinct list.

I'm curious if there is another means of getting django data query to
return a distinct list, or if somehow I'm using distinct incorrectly?

Also is there anyway to see the verbose/verbatum SQL these django
queries are generating?


--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---

Reply via email to