soon to be attached is a slightly more involved patch (white space used is different from source), wraps the original query inside an alias _msr, and deals with TextClause based order_by as well...
the order_by choosen for row_number over is oid in the case when there is no order_by specified, there might be a more faithful implementation that uses an aliased null column and order by that in row_number over... Lei On Jan 10, 8:33 pm, Esceo <[EMAIL PROTECTED]> wrote: > Hi Paul, > > not quite, at least the patch above doesnt do that... > > Lei > > On Jan 10, 8:02 pm, "Paul Johnston" <[EMAIL PROTECTED]> wrote: > > > > > Hi, > > > > adding row_number will render a distinct clause useless... > > > Actually, this isn't a problem, as the distinct goes in an inner query, and > > the row_number is only in the outer query. > > > I did have this mostly working, just need a final push to get it finished > > and committed. > > > Paul- Hide quoted text - > > - Show quoted text - --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/sqlalchemy?hl=en -~----------~----~----~----~------~----~------~--~---
