Groups > comp.databases.postgresql > #583

Re: JDBC - move cursor forward in a forward only ResultSet

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> (permalink)
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

Show key headers only | View raw

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

Back to comp.databases.postgresql | Previous | Next — Previous in thread | Next in thread | Find similar

Thread

JDBC - move cursor forward in a forward only ResultSet Magnus Warker <magnux@mailinator.com> - 2014-08-12 18:58 +0200
  Re: JDBC - move cursor forward in a forward only ResultSet Kees Nuyt <k.nuyt@nospam.demon.nl> - 2014-08-13 17:23 +0200
    Re: JDBC - move cursor forward in a forward only ResultSet Magnus Warker <magnux@mailinator.com> - 2014-08-14 05:46 +0200
      Re: JDBC - move cursor forward in a forward only ResultSet Jasen Betts <jasen@xnet.co.nz> - 2014-08-14 06:55 +0000
      Re: JDBC - move cursor forward in a forward only ResultSet Kees Nuyt <k.nuyt@nospam.demon.nl> - 2014-08-14 11:04 +0200
      Re: JDBC - move cursor forward in a forward only ResultSet Dimitri Fontaine <dimitri@2ndQuadrant.fr> - 2014-08-15 20:12 +0200
        Re: JDBC - move cursor forward in a forward only ResultSet Jasen Betts <jasen@xnet.co.nz> - 2014-08-16 23:36 +0000

csiph-web