we will have it eventually. for now you can build ColumnElement constructs yourself using the @compiles extension, http://www.sqlalchemy.org/docs/reference/ext/compiler.html (or just literal strings if your needs are simple).
On May 24, 2010, at 1:13 PM, Jon Nelson wrote: > I have a query which requires the use of windowing functions in postgresql. > Specifically, I require > > select distinct S.c1, first_value(c2) over (partition by S.c1 order by > c2 desc) c3 > from .... > > How might I accomplish this? Will there be windowing function support > in an upcoming release of SA? > > -- > Jon > > -- > You received this message because you are subscribed to the Google Groups > "sqlalchemy" group. > To post to this group, send email to sqlalch...@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. > -- You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To post to this group, send email to sqlalch...@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.