I am doing this.
featured = Product.objects.filter(is_featured=True,
is_active=True).order_by('?')[:4]
On Tuesday, March 19, 2013 12:03:28 AM UTC-4, Mike Dewhirst wrote:
>
> No really, I want a maximum of ten random records from the database
> (Django 1.4, Postgres 9.1).
>
>
> Looking at the docs this seems to be what I want ...
>
> Items.objects.filter(name__icontains=term).order_by('?')[:10]
>
> Is there a better way?
>
> Would .order_by() be quicker if I wasn't too concerned about true
> randomness?
>
> Do I need try: except: pass to silence errors if there aren't any results?
>
> Thanks
>
> Mike
>
>
>
>
--
You received this message because you are subscribed to the Google Groups
"Django users" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to django-users+unsubscr...@googlegroups.com.
To post to this group, send email to django-users@googlegroups.com.
Visit this group at http://groups.google.com/group/django-users?hl=en.
For more options, visit https://groups.google.com/groups/opt_out.
