On Dec 27, 2011, at 8:37 PM, Vlad K. wrote: > > Hi all. > > > I need to select some rows where pkey is in a sequence. How do I order by > that very sequence? > > > images_all = > session.query(AdImage).filter(AdImage.image_id.in_(images)).order_by( ? > ).all() > > > Postgresql backend.
typically with case(): order_by( case([ (Adimage.id == 3, "A"), (Adimage.id == 1, "B"), (Adimage.id == 9, "C"), ]) ) unless you can use a simpler transformation on AdImage.id that converts it into a sortable value. The above can be generalized: case([(AdImage.id == value, literal(index)) for index, value in enumerate(images)]) -- You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To post to this group, send email to sqlalchemy@googlegroups.com. To unsubscribe from this group, send email to sqlalchemy+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/sqlalchemy?hl=en.