On Jan 25, 2006, at 1:02 PM, Mitch Skinner wrote:
As far as oracle goes, my experience stopped at 8i, but have you seen the following link? IMHO there's a nice cross-database discussion of limit and offset, that includes an Oracle alternative to rownum--ROW_NUMBER(): http://troels.arvin.dk/db/rdbms/#select-limit
I have integrated the ROW_NUMBER() OVER (ORDER BY ...) technique described in that document into the Oracle module, changeset 913 - lazy/eager loads with LIMIT/OFFSET unit tests now pass in Oracle.
At the moment it does make a slight change to the incoming Select() statement which is not ideal, in the case that someone is using the same select() object amongst different databases...while I think such a scenario is pretty rare (because select() objects are usually local, and maybe because the typical Oracle shop isnt swapping the exact same SELECT statements out to other brands of database in the same application instance), nonetheless this should eventually be improved, so I added a ticket for that.
------------------------------------------------------- This SF.net email is sponsored by: Splunk Inc. Do you grep through log files for problems? Stop! Download the new AJAX search engine that makes searching your log files as easy as surfing the web. DOWNLOAD SPLUNK! http://sel.as-us.falkag.net/sel?cmd=lnk&kid=103432&bid=230486&dat=121642 _______________________________________________ Sqlalchemy-users mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/sqlalchemy-users
