Groups > comp.databases.postgresql > #583

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

From	Dimitri Fontaine <dimitri@2ndQuadrant.fr>
Newsgroups	comp.databases.postgresql
Subject	Re: JDBC - move cursor forward in a forward only ResultSet
Date	2014-08-15 20:12 +0200
Organization	A noiseless patient Spider
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>

Show all headers | 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