django - order query set by postgres function

Question

My initial question was here and was related to the postgres backend. Postgres subquery, ordering by subquery

Now my problem has moved onwards to the Django ORM layer. I essentially want to order a query by a postgres function ('idx', taken from the above stackoverflow work)

I've gone through trying to use model.objects.extra(order_by ) or simply order_by but I believe both of these need the order_by parameter to be an attribute or a field known to Django.

I'm trying to think how to solve this without having to revert to using an entirely raw SQL query through a model manager.

Daniel Roseman · Accepted Answer · 2010-04-13 11:08:59Z

6

You can use extra to add the function result to your query and then order by it. Something like:

MyModel.objects.extra(select={'idx': 'idx(foo, bar)'}, order_by=['idx'])

answered Apr 13, 2010 at 11:08

Daniel Roseman

602k68 gold badges911 silver badges924 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

akiva Over a year ago

that's a brilliant answer. I wish I could give you more than a plus

Collectives™ on Stack Overflow

django - order query set by postgres function

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related