X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id B39ED528D1 for ; Tue, 17 May 2005 19:13:54 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 10907-06 for ; Tue, 17 May 2005 22:13:49 +0000 (GMT) Received: from boutiquenumerique.com (boutiquenumerique.com [82.67.9.10]) by svr1.postgresql.org (Postfix) with ESMTP id 879C4528C9 for ; Tue, 17 May 2005 19:13:47 -0300 (ADT) Received: (qmail 31789 invoked from network); 18 May 2005 00:14:14 +0200 Received: from unknown (HELO localhost) (boutiquenumerique-lists@192.168.0.4) by boutiquenumerique.com with SMTP; 18 May 2005 00:14:14 +0200 To: =?iso-8859-15?Q?Ragnar_Hafsta=F0?= , Alain Cc: Sql-Postgre Subject: Re: Does Postgresql have a similar pseudo-column "ROWNUM" as References: <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> Message-ID: Date: Wed, 18 May 2005 00:13:46 +0200 From: PFC Organization: =?iso-8859-15?Q?La_Boutique_Num=E9rique?= Content-Type: text/plain; format=flowed; delsp=yes; charset=iso-8859-15 MIME-Version: 1.0 Content-Transfer-Encoding: 8bit In-Reply-To: <1116367382.9362.11.camel@localhost.localdomain> User-Agent: Opera M2(BETA2)/8.0 (Linux, build 987) X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.006 tagged_above=0 required=5 tests=AWL X-Spam-Level: X-Archive-Number: 200505/143 X-Sequence-Number: 21456 > 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.