Groups > comp.databases.postgresql > #584

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

From	Jasen Betts <jasen@xnet.co.nz>
Newsgroups	comp.databases.postgresql
Subject	Re: JDBC - move cursor forward in a forward only ResultSet
Date	2014-08-16 23:36 +0000
Organization	JJ's own news server
Message-ID	<lsopti$aag$1@gonzo.reversiblemaps.ath.cx> (permalink)
References	<lsdh3n$ugq$1@news.m-online.net> <qf0nu9ps55b1tvs8sd7gscaitfdgjjqj7i@dim53.demon.nl> <lshbf8$nl0$1@news.m-online.net> <m2wqa9tyem.fsf@2ndQuadrant.fr>

Show all headers | View raw

On 2014-08-15, Dimitri Fontaine <dimitri@2ndQuadrant.fr> wrote:
> 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

suppose you want page 500 if 1100 , you'd have to mash next 500 times,

if you are ordering on three columns and only the least significant
is unique the where gets more complex.

 where  a=$a and ( b=$b and ( c>$c ) or b > $b) or a> $a order by a,b,c
  
dunno if postgres can see how to satisfy that with an index scan or not.

one help fpr the first problem is to add in links to significant values of "a"

-- 
umop apisdn


--- news://freenews.netfront.net/ - complaints: news@netfront.net ---

Back to comp.databases.postgresql | Previous | Next — Previous 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