Received: from ns.infoset.cz (ns.infoset.cz [194.213.32.210]) by hub.org (8.9.3/8.9.3) with ESMTP id MAA02560 for ; Wed, 29 Sep 1999 12:18:42 -0400 (EDT) (envelope-from dpeder@infoset.cz) Received: from WinProxy.anywhere ([62.168.15.178]) by ns.infoset.cz (8.8.7/8.8.7) with SMTP id SAA06973 for ; Wed, 29 Sep 1999 18:20:23 +0200 Received: from 192.168.1.1 by 192.168.1.3 (WinProxy); Wed, 29 Sep 1999 18:20:54 +0100 Received: by Dan with Microsoft Mail id <01BF0AA6.E010A7A0@Dan>; Wed, 29 Sep 1999 18:17:22 +0100 Message-ID: <01BF0AA6.E010A7A0@Dan> From: =?iso-8859-2?Q?Daniel_P=E9der?= To: "pgsql-sql@postgreSQL.org" Subject: RE: [SQL] Limit rows Date: Wed, 29 Sep 1999 18:17:21 +0100 MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit Yes, in the 6.x.x. manual is the: select * from mytab [ LIMIT { count | ALL } [ { OFFSET | , } count ] ] ; -----Original Message----- From: Mark Jewiss [SMTP:Mark.Jewiss@knowledge.com] Sent: Wednesday, September 29, 1999 4:17 PM To: pgsql-sql@postgreSQL.org Subject: [SQL] Limit rows 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 ************