"Mitch Vincent" <mitch(at)venux(dot)net> writes:
> ... use LIMIT X to only grab the first X records from
> a result set. Then on the next page you say LIMIT X OFFSET X (in this
> example it's more of a <Next 10 results> type of thing).
Don't forget to use an ORDER BY clause that constrains the rows into a
unique order, else you may get inconsistent results from the successive
LIMITed queries.
regards, tom lane