pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  

help / color / mirror / Atom feed

From: PFC <lists@boutiquenumerique.com>
To: Ragnar Hafstað <gnari@simnet.is>
To: Alain <alainm@pobox.com>
Cc: Sql-Postgre <pgsql-sql@postgresql.org>
Subject: Re: Does Postgresql have a similar pseudo-column "ROWNUM" as
Date: Wed, 18 May 2005 00:13:46 +0200
Message-ID: <op.sqxxc81sth1vuj@localhost> (raw)
In-Reply-To: <1116367382.9362.11.camel@localhost.localdomain>
References: <DCD4903594CCF34CAFE200BDF3448D8D5B291A@tshuscodenmbx01.ERF.THOMSON.COM>
	<1116367382.9362.11.camel@localhost.localdomain>
	<428A3B54.4070902@pobox.com>
	<1116353539.26520.5.camel@localhost.localdomain>
	<428A2E81.2060501@pobox.com>
	<20050517170636.GC12405@phlogiston.dyndns.org>


> your subsequent selects are
> select ... from tab WHERE skey>skey_last
>                        OR (skey=skey_last AND pkey>pkey_last)
>                     ORDER BY skey,pkey
>                     LIMIT 100 OFFSET 100;

	why offset ?
	you should be able to use the skey, pkey values of the last row on the  
page to show the next page, no need for offset then.

view thread (17+ messages)  latest in thread

Message-ID: <op.sqxxc81sth1vuj@localhost>
Permalink:  ../op.sqxxc81sth1vuj@localhost/
Also on:    postgresql.org/message-id/op.sqxxc81sth1vuj@localhost

copy link · copy postgr.es

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-sql@postgresql.org
  Cc: lists@boutiquenumerique.com, gnari@simnet.is, alainm@pobox.com
  Subject: Re: Does Postgresql have a similar pseudo-column "ROWNUM" as
  In-Reply-To: <op.sqxxc81sth1vuj@localhost>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox