Re: Selecting one field

On Thu, 2007-10-25 at 12:52 +1000, Malcolm Tredinnick wrote: [...] > Use my_queryset.values(...).distinct(). However, be aware of bug #2939 > and the fact that you can only use one value in the values() call on > trunk. Except possibly on MySQL, this would fail: > > my_queryset.values('fo

Re: Selecting one field

On Wed, 2007-10-24 at 06:41 +, Rufman wrote: > hey > > if I use the Django db api it automatically does SELECT * FROM Well, for accuracy, no it doesn't. But it does explicitly list all fields. > How > can I select only one (or a certain number of fields) so that I can > run a distinct

Selecting one field

hey if I use the Django db api it automatically does SELECT * FROM How can I select only one (or a certain number of fields) so that I can run a distinct query. i.e something like this in sql: SELECT field FROM table. Which would lead to the distinct query: SELECT DISTINCT field FROM table. i