Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id DC2094759BD for ; Sat, 21 Dec 2002 13:38:07 -0500 (EST) Received: from mailout09.sul.t-online.com (mailout09.sul.t-online.com [194.25.134.84]) by postgresql.org (Postfix) with ESMTP id D03BF474E5C for ; Sat, 21 Dec 2002 13:38:06 -0500 (EST) Received: from fwd11.sul.t-online.de by mailout09.sul.t-online.com with smtp id 18PoVh-0000T8-03; Sat, 21 Dec 2002 19:38:05 +0100 Received: from fraxinus.reticulum (520013531845-0001@[217.225.156.209]) by fmrl11.sul.t-online.com with esmtp id 18PoVW-2IHQwqC; Sat, 21 Dec 2002 19:37:54 +0100 Received: from ks by fraxinus.reticulum with local (Exim 3.36 #1 (Debian)) id 18PoQS-0000M4-00 for ; Sat, 21 Dec 2002 19:32:40 +0100 Date: Sat, 21 Dec 2002 19:32:37 +0100 From: knut.suebert@web.de To: pgsql-sql@postgresql.org Subject: Re: Need help paging through record sets Message-ID: <20021221183237.GD964@fraxinus.reticulum> References: <20021220230150.474DC103C6@polaris.pinpointresearch.com> Mime-Version: 1.0 Content-Type: text/plain; charset=iso-8859-15 Content-Disposition: inline In-Reply-To: <20021220230150.474DC103C6@polaris.pinpointresearch.com> User-Agent: Mutt/1.4i X-No-Archive: yes X-Sender: 520013531845-0001@t-dialin.net X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200212/253 X-Sequence-Number: 10841 Steve Crawford schrieb: > select * from foo order by date limit 100 offset 100; > On Friday 20 December 2002 12:53 pm, cmccormick@mailsnare.net wrote: > > 1. SORT records by the date field, descending select * from foo order by date desc limit 100 offset 100; ^^^^