Hello Malcolm Tredinnick! On Wed, 04 Oct 2006 11:27:31 +1000 you wrote: > > On Tue, 2006-10-03 at 18:21 +0400, Grigory Fateyev wrote: > > Hello James Bennett! > > On Tue, 3 Oct 2006 08:28:02 -0500 you wrote: > > > > > > > > On 10/3/06, Grigory Fateyev <[EMAIL PROTECTED]> wrote: > > > > I have a list of ip in table, but this ip repeats many times. I > > > > need to show each ip only once with some statistic. How to do > > > > this? > > > > > > http://www.djangoproject.com/documentation/db_api/#distinct > > > > I don't get it, Blog.objects.all().distinct() is't working like sql > > query: select distinct column from blog;? > > In both SQL and Django, "distinct" means "select distinct rows". So if > you run Blog.objects.all().distinct(), you will have every row > returned, since each row has a distinct value in the primary key > column and thus is not identical to any other row. > > Something like Blog.objects.values('ip').distinct() will extract all > the distinct values from the "ip" column, however, as Rajesh points > out, elsewhere, if you also want to collect other statistics, you are > going to need to use custom SQL. > > Regards, > Malcolm
Thanks Malcolm for helping! -- ÷ÓÅÇÏ ÎÁÉÌÕÞÛÅÇÏ! çÒÉÇÏÒÉÊ greg [at] anastasia [dot] ru ðÉÓØÍÏ ÏÔÐÒÁ×ÌÅÎÏ: 2006/10/04 20:06 --~--~---------~--~----~------------~-------~--~----~ 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 [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/django-users -~----------~----~----~----~------~----~------~--~---
