On Fri, Mar 14, 2008 at 08:53:04AM -0400, [EMAIL PROTECTED] wrote: > I have been playing about with scrollable result sets (Cursors) in > Oracle/OCI and have noticed that there has been some discussion > about it before on the list > > You can find the discussion here > > http://perl.markmail.org/search/?q=list%3Aorg.perl.dbi-dev+fetch_scroll#query:list%3Aorg.perl.dbi-dev%20fetch_scroll+page:1+mid:xqwmgau3zesiyo7n+state:results > > and here > > http://perl.markmail.org/search/?q=from%3A%22Tim+Bunce%22+scroll+cursor#query:from%3A%22Tim%20Bunce%22%20scroll%20cursor+page:1+mid:t3xvtu3rcqarszsx+state:results > > > Reading through these I see that basically each Database has its own > flavour or scrollable results set from a select i.e. > > Informix Scrollable and updateable > MySQL semi Scrollable > Oracle Scrollable and read only > SQLServer Scrollable and read only > Scrollable and updateable > > So my proposal is to stub in > > fetch_scroll > > in DBI
Section 4.32 of the SQL:2008 standard defines all the different things cursors are supposed to do. I don't know of any implementation that does more with them than that. Cheers, David. -- David Fetter <[EMAIL PROTECTED]> http://fetter.org/ Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter Skype: davidfetter XMPP: [EMAIL PROTECTED] Remember to vote! Consider donating to Postgres: http://www.postgresql.org/about/donate
