Re: [rfc] Row limit support for Pear DB

Tomas V.V.Cox wrote: (snip)

## Planed Support ## mysql -> altering query pgsql -> altering query oci8 -> altering query ibase -> unsupported rest -> emulated with the fetch row by number feature (Note: for the last two I'll be glad to hear better ideas)

I THINK that oracle has something like this: SELECT * WHERE rownum BETWEEN ($from,$to) i'm not sure if oracle supports the BETWEEN syntax though but otherwise it would be SELECT * WHERE rownum <= $from AND rownum >= $to Although it was more than a year ago i used oracle, and i didn't use it very much. :)

This feature is limited to SELECT statements

In mysql it is possible to use LIMIT with UPDATE and DELETE. If the programmer is sure that the query will only update x row(s), so that if you run "UPDATE table SET something='string' WHERE id='123' LIMIT x" it won't run trough the rest of the table searching for something it already found, i'm not sure how it works if it's a primary/unique index though.

Tomas V.V.Cox