Malcolm, As you guessed, it was the default ordering that was causing the problem for me. After removing the default ordering from the model, distinct() works as expected.
I still find it strange that distinct().count() was not affected by the model's default ordering, while the actual list of records was affected. Thanks for your help, Tyler --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---