Hi Eric,
Wouldn't LIMIT and OFFSET do the trick for you?
Good point! I have not considered LIMIT and OFFSET.
However applying it directly on the original query
is very expensive, because it evaluates the query
on each call:
SELECT *
FROM data
WHERE name like 'foo%' ORDER number
LIMIT 50 OFFSET 99; -- retrieve column 100-150
I could use it on the query of my view1 table:
SELECT *
FROM data
WHERE oid IN
(SELECT dataid
FROM view1
WHERE LIMIT 50 OFFSET 99)
ORDER BY number; -- this sorting is needed, to
-- get the result in order!
But I'm still assuming that the view1 table is in the
order it was created (but no assumptions on the rowid
are needed!)...
Michael
