n.b. This question has been coped with at least two times in the last
two weeks at comp.lang.perl.misc.
On Thu, 29 Nov 2001 16:29:03 -0500, Charles Day wrote:
>We use SQL7/SQL 2000, and PostgreSQL 7. We can do this on the
>scripting side, but don't want to fetch all rows each time.
The chances of you needing, say, rows 2101 through 2110 are pretty slim.
People generally will browse through the first couple of pages, and then
give up and redo a finer search.
So, if your DB doesn't support LIMIT, just fetching the rows one by one
until you've got to the point where you get the ones you want now, that
looks practically feasable.
Don't forget to "finish", as you will generally not read until the end.
--
Bart.
