Re: [Sqlalchemy-tickets] [sqlalchemy] #1844: support for postgresql windowing functions

[sqlalchemy <mi...@zz...>]

#1844: support for postgresql windowing functions
-------------------------+--------------------------------------------------
 Reporter:  guest        |          Owner:  zzzeek           
     Type:  enhancement  |         Status:  new              
 Priority:  high         |      Milestone:  0.6.xx           
Component:  sql          |       Severity:  major - 1-3 hours
 Keywords:               |   Status_field:  awaiting triage  
-------------------------+--------------------------------------------------

Comment(by zzzeek):

 also I just had to use a window the other day, its pretty easy in the
 usual case, `from_self()` makes the usual "subquery from self" a snap:

 {{{
 for x, in Session.query(SomeClass.x, literal_column("ROW_NUMBER OVER
 (ORDER BY foo.bar) AS rownum")).\
                 from_self(SomeClass.x).\
                 filter("rownum %% %d=1" % modulus)
 }}}

-- 
Ticket URL: <http://www.sqlalchemy.org/trac/ticket/1844#comment:7>
sqlalchemy <http://www.sqlalchemy.org/>
The Database Toolkit for Python