Received: from office.knowledge.com (IDENT:exim@office.knowledge.com [195.40.167.196]) by hub.org (8.9.3/8.9.1) with ESMTP id FAA38234 for ; Thu, 29 Apr 1999 05:24:48 -0400 (EDT) (envelope-from mark@knowledge.com) Received: from mark (helo=localhost) by office.knowledge.com with local-esmtp (Exim 2.10 #1) id 10cn3m-0003rF-00; Thu, 29 Apr 1999 10:24:46 +0100 Date: Thu, 29 Apr 1999 10:24:46 +0100 (BST) From: Mark Jewiss To: Chris Bitmead cc: pgsql-sql@postgresql.org Subject: Re: [SQL] LIMIT In-Reply-To: <3727F277.EE6B553E@bigfoot.com> Message-ID: MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII Sender: Mark Jewiss > > Could someone give me an example of a select * with LIMIT > > used by 6.5? > > SELECT * FROM foobar LIMIT 100 Or you could use ROWCOUNT... set rowcount = 10 select * from table Regards, Mark. -- Mark Jewiss Knowledge Matters Limited