Path: csiph.com!v102.xanadu-bbs.net!xanadu-bbs.net!feeder.erje.net!eu.feeder.erje.net!eternal-september.org!feeder.eternal-september.org!news.eternal-september.org!.POSTED!not-for-mail
From: Dimitri Fontaine <dimitri@2ndQuadrant.fr>
Newsgroups: comp.databases.postgresql
Subject: Re: JDBC - move cursor forward in a forward only ResultSet
Date: Fri, 15 Aug 2014 20:12:33 +0200
Organization: A noiseless patient Spider
Lines: 10
Message-ID: <m2wqa9tyem.fsf@2ndQuadrant.fr>
References: <lsdh3n$ugq$1@news.m-online.net> <qf0nu9ps55b1tvs8sd7gscaitfdgjjqj7i@dim53.demon.nl> <lshbf8$nl0$1@news.m-online.net>
Mime-Version: 1.0
Content-Type: text/plain
Injection-Info: mx05.eternal-september.org; posting-host="b4cd7ce2dcd601d09567d71a2b24a9e9"; logging-data="13249"; mail-complaints-to="abuse@eternal-september.org";	posting-account="U2FsdGVkX1/CYqj7XkRUEuXgo5E9g2XF"
User-Agent: Gnus/5.13001 (Ma Gnus v0.10) Emacs/24.3.91 (darwin)
Cancel-Lock: sha1:sHInNvL3ekHpp4kNpDt84DUY1WI= sha1:ZOikUTsTzUbXdDwd+iIUsNJsdX0=
Xref: csiph.com comp.databases.postgresql:583

Magnus Warker <magnux@mailinator.com> writes:
> I don't know a WHERE-condition to select rows 11-20 from a result set that I
> would have got without this condition.

  http://use-the-index-luke.com/fr/blog/2013-07/pagination-done-the-postgresql-way
  http://use-the-index-luke.com/no-offset

-- 
Dimitri Fontaine
PostgreSQL DBA, Architecte