your subsequent selects are
select ... from tab WHERE skey>skey_last
OR (skey=skey_last AND pkey>pkey_last)
ORDER BY skey,pkey
LIMIT 100 OFFSET 100;
why offset ?
you should be able to use the skey, pkey values of the last row on the page to show the next page, no need for offset then.
---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster
