Re: sql query: how to

2010-09-27 Thread chris hendrix
yeah i was looking at something like that... actually let me correct what i'm needing to do: select year(fieldname) as pubyear from table order by year(fieldname) asc On 09/27/2010 01:15 AM, akaariai wrote: The most efficient? Exactly that using raw SQL. I think something along the followin

Re: sql query: how to

2010-09-26 Thread akaariai
The most efficient? Exactly that using raw SQL. I think something along the following will also work: Foo.objects.only('fieldname').value_list().distinct().order_by('fieldname'). - Anssi On Sep 27, 5:49 am, Bobby Roberts wrote: > what is the most efficient way to do the following sql command in

sql query: how to

2010-09-26 Thread Bobby Roberts
what is the most efficient way to do the following sql command in django? select distinct fieldname from table order by fieldname -- You received this message because you are subscribed to the Google Groups "Django users" group. To post to this group, send email to django-us...@googlegroups.co