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

Поиск
Список
Период
Сортировка
От Oliver Jowett
Тема Re: very large result sets and ResultSet.relative() to jump to a desired offset
Дата
Msg-id 48D9D794.2010006@opencloud.com
обсуждение исходный текст
Ответ на very large result sets and ResultSet.relative() to jump to a desired offset  ("Matt Magoffin" <postgresql.org@msqr.us>)
Ответы Re: very large result sets and ResultSet.relative() to jump to a desired offset  ("Matt Magoffin" <postgresql.org@msqr.us>)
Список 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

В списке pgsql-jdbc по дате отправления:

Предыдущее
От: "Matt Magoffin"
Дата:
Сообщение: very large result sets and ResultSet.relative() to jump to a desired offset
Следующее
От: "Matt Magoffin"
Дата:
Сообщение: Re: very large result sets and ResultSet.relative() to jump to a desired offset