Advertisement
Guest User

Untitled

a guest
Mar 24th, 2017
66
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.43 KB | None | 0 0
  1. queryset = queryset.distinct('article_hash').order_by('article_hash')
  2. queryset = querset.order_by('create_time')
  3.  
  4. SELECT DISTINCT ON expressions must match initial ORDER BY expressions
  5.  
  6. queryset = queryset.distinct('article_hash','create_time')
  7. .order_by('article_hash', 'create_time')
  8.  
  9. select distinct on (tb.article_hash, tb.create_time), tb.id
  10. from tb
  11. order by tb.article_hash asc, tb.create_time asc
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement