Received: from office.knowledge.com (office.knowledge.com [195.40.167.196]) by hub.org (8.9.3/8.9.3) with ESMTP id MAA00790 for ; Wed, 29 Sep 1999 12:09:50 -0400 (EDT) (envelope-from Mark.Jewiss@knowledge.com) Received: from mark (helo=localhost) by office.knowledge.com with local-esmtp (Exim 2.10 #1) id 11WMI6-0003XD-00; Wed, 29 Sep 1999 17:09:14 +0100 Date: Wed, 29 Sep 1999 17:09:14 +0100 (BST) From: Mark Jewiss To: Oleg Bartunov cc: pgsql-sql@postgresql.org Subject: Re: [SQL] Limit rows In-Reply-To: Message-ID: MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII Hello, On Wed, 29 Sep 1999, Oleg Bartunov wrote: > select * from table limit 5,10; Excellent, that works perfectly. I've done a grep over the html documentation, and can't see anything regarding the limit feature (if I've just missed it and it is there could someone provide a pointer please?). I'm interested now in how this method actually works - is a query performed that reads all of the rows of a table into memory, and then the non-requested rows are discarded before the results are sent back? I'm interested in how this would work with a massive table...... Regards, Mark. -- Mark Jewiss Knowledge Matters Limited http://www.knowledge.com