Matt Magoffin wrote:
>> I'd suggest using LIMIT/OFFSET in your query.
>>
>> -O
>
> Hmm, I had thought of that but was hoping to stay just in generic JDBC,
> without Postgres specific SQL changes.
Doing it in the query does have the advantage that the server can
potentially come up with a better query plan.. assuming that it's common
to page through less than the full query output.
-O