Hi, I reported a bug #536 almost a year ago, but looks like it didn't catch too much attention within new 0.4 branch. I want to revise it. The problem only occur in ORACLE instance where someone want to do pagination and select distinct rows in chunks. The correct way to do this in ORACLE is the following:
select * from (SELECT x.*, rownum as rnum FROM (query) x) where rnum between min and max; For those who are interesting this link provides full discussion. http://progcookbook.blogspot.com/2006/02/using-rownum-properly-for-pagination.html Thank you, Valentin. --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
