2011/3/8 Łukasz Rekucki <lreku...@gmail.com>: > On 8 March 2011 14:01, Florian Apolloner <f.apollo...@gmail.com> wrote: >> Hi, >> >> On Mar 5, 9:30 am, akaariai <akaar...@cc.hut.fi> wrote: >>> on(primary_key) id, val1, ... from table order by primary_key this >>> would solve the problem. >> >> Is "DISTINCT ON" part of the SQL standard at all? >> > > Quoting PostreSQL docs: > >> The DISTINCT ON clause is not part of the SQL standard and is sometimes >> considered bad style because of the potentially indeterminate nature of its >> results. With judicious use of GROUP BY and subqueries in FROM the construct >> can be avoided, but it is often the most convenient alternative. > > It's also supported by Oracle, AFAIK. >
I forgot to mention there's a ticket to support it in ORM: http://code.djangoproject.com/ticket/14139. -- Łukasz Rekucki -- You received this message because you are subscribed to the Google Groups "Django developers" group. To post to this group, send email to django-developers@googlegroups.com. To unsubscribe from this group, send email to django-developers+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/django-developers?hl=en.