Received: from office.knowledge.com (office.knowledge.com [195.40.167.196]) by hub.org (8.9.3/8.9.3) with ESMTP id LAA90479 for ; Wed, 29 Sep 1999 11:17:34 -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 11WLTb-0005IK-00 for pgsql-sql@postgresql.org; Wed, 29 Sep 1999 16:17:03 +0100 Date: Wed, 29 Sep 1999 16:17:03 +0100 (BST) From: Mark Jewiss To: pgsql-sql@postgresql.org Subject: Limit rows Message-ID: MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII Hello, I'm still thinking about ways to extract specific rows of data from a table, whilst ignoring others. i.e. I want to see rows 3-7 inclusive from a table. Assume that I don't have a numerical identifier - I do, but I can't use that as rows from this table may be deleted at some point, thereby knocking the id row out of sequence. Basically I want to be able to do something like this: select * from table ignore 10 limit 5; I can't use cursors, which are ideal for this I know. Is there such a thing in SQL or pgsql specifically? If not I'll have to write something.... Regards, Mark. -- Mark Jewiss Knowledge Matters Limited http://www.knowledge.com