Received: from bologna.nettuno.it (bologna.nettuno.it [193.43.2.1]) by hub.org (8.9.3/8.9.1) with ESMTP id KAA76118 for ; Thu, 29 Apr 1999 10:04:24 -0400 (EDT) (envelope-from jose@sferacarta.com) Received: from proxy.sferacarta.com (mail@sfcabop1.nettuno.it [193.207.10.213]) by bologna.nettuno.it (8.8.6/8.8.6/NETTuno 3.1) with ESMTP id QAA04429; Thu, 29 Apr 1999 16:04:16 +0200 (MDT) Received: from rosso.sferacarta.com (sferacarta.com) [10.20.30.5] by proxy.sferacarta.com with esmtp (Exim 2.05 #1 (Debian)) id 10ctGI-00007K-00; Thu, 29 Apr 1999 16:02:06 +0000 Message-ID: <37286667.F584462D@sferacarta.com> Date: Thu, 29 Apr 1999 16:02:15 +0200 From: =?iso-8859-1?Q?Jos=E9?= Soares X-Mailer: Mozilla 4.5 [it] (Win95; I) X-Accept-Language: it MIME-Version: 1.0 To: Mark Jewiss CC: Chris Bitmead , hackers Subject: Re: [SQL] LIMIT References: Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Mark Jewiss ha scritto: > > > 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 I know nothing about SET ROWCOUNT, it doesn't work for me. I see v6.5 accepts still SET QUERY_LIMIT TO # but it doesn't work too. ______________________________________________________________ PostgreSQL 6.5.0 on i586-pc-linux-gnu, compiled by gcc 2.7.2.3 ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ Jose'