Re: [sqlalchemy] Window function support?

2010-05-24 Thread Michael Bayer
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

[sqlalchemy] Window function support?

2010-05-24 Thread Jon Nelson
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? --