extra row_number does not work

11 views
Skip to first unread message

Ye Xu

unread,
Jul 24, 2015, 3:16:58 PM7/24/15
to Django users
Hi,

I have two models, as follow,
class Feed(models.Model):
    user=ForeignKey(...)

class Comment(models.Model):
    feed=ForeignKey(Feed, ...)
    comment_text=TextField(...)


I want get last two comments for each feed, the statement is:
Comment.objects.all().extr(select={'row_num': 'row_number() over (partition by feed_id order by id desc', where=['row_num<3']}

After run, Django told me these error:
....
Django Version: 1.8.2
Exception Type: ProgrammingError
Exception Value:
column "row_num" does not exist
LINE 1: ...nt"."create_date" FROM "footprint_comment" WHERE (row_num < ...
....

But remove where parameter, it works.
Comment.objects.all().extr(select={'row_num': 'row_number() over (partition by feed_id order by id desc'}

Reply all
Reply to author
Forward
0 new messages