Re: very large result sets and ResultSet.relative() to jump to a desired offset

From: Oliver Jowett <oliver(at)opencloud(dot)com>
To: Matt Magoffin <postgresql(dot)org(at)msqr(dot)us>
Cc: pgsql-jdbc(at)postgresql(dot)org
Subject: Re: very large result sets and ResultSet.relative() to jump to a desired offset
Date: 2008-09-24 06:00:52
Message-ID: 48D9D794.2010006@opencloud.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

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

In response to

Responses

Browse pgsql-jdbc by date

  From Date Subject
Next Message Matt Magoffin 2008-09-24 06:34:41 Re: very large result sets and ResultSet.relative() to jump to a desired offset
Previous Message Matt Magoffin 2008-09-24 01:56:18 very large result sets and ResultSet.relative() to jump to a desired offset