Received: from localhost.localdomain (h246.ozemail2.ozemail.com.au [203.108.14.246]) by hub.org (8.9.3/8.9.1) with ESMTP id BAA10145 for ; Thu, 29 Apr 1999 01:45:46 -0400 (EDT) (envelope-from chris.bitmead@bigfoot.com) Received: from bigfoot.com (localhost [127.0.0.1]) by localhost.localdomain (8.8.7/8.8.7) with ESMTP id PAA00858 for ; Thu, 29 Apr 1999 15:47:35 +1000 Sender: chris@localhost.localdomain Message-ID: <3727F277.EE6B553E@bigfoot.com> Date: Thu, 29 Apr 1999 05:47:35 +0000 From: Chris Bitmead X-Mailer: Mozilla 4.51 [en] (X11; I; Linux 2.2.6 i686) X-Accept-Language: en MIME-Version: 1.0 To: pgsql-sql@postgreSQL.org Subject: Re: [SQL] LIMIT References: <199904290529.WAA29644@ezwebhost.com> Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit "Mr. Poet" wrote: > > Could someone give me an example of a select * with LIMIT > used by 6.5? SELECT * FROM foobar LIMIT 100