Postgres Pro
Downloads
Home   >   mailing lists

Re: very large result sets and ResultSet.relative() to jump to a desired offset - Mailing list pgsql-jdbc

From Oliver Jowett
Subject Re: very large result sets and ResultSet.relative() to jump to a desired offset
Date
Msg-id 48D9D794.2010006@opencloud.com
Whole thread Raw
In response to very large result sets and ResultSet.relative() to jump to a desired offset  ("Matt Magoffin" <postgresql.org@msqr.us>)
Responses Re: very large result sets and ResultSet.relative() to jump to a desired offset  ("Matt Magoffin" <postgresql.org@msqr.us>)
List pgsql-jdbc
Tree view 
Matt Magoffin wrote:

> However, I'd like to be able to jump to the Xth result and display only Y
> results, i.e. support pages of results and allow jumping to arbitrary
> pages and thus arbitrary offsets in the result query.

I'd suggest using LIMIT/OFFSET in your query.

-O

pgsql-jdbc by date:

Previous
From: "Matt Magoffin"
Date:
Subject: very large result sets and ResultSet.relative() to jump to a desired offset
Next
From: "Matt Magoffin"
Date:
Subject: Re: very large result sets and ResultSet.relative() to jump to a desired offset