Received: from trends.net (root@clio.trends.ca [209.47.148.2]) by hub.org (8.9.3/8.9.1) with ESMTP id WAA00816 for ; Thu, 22 Apr 1999 22:48:27 -0400 (EDT) (envelope-from chris.bitmead@bigfoot.com) Received: from localhost.localdomain (h246.ozemail2.ozemail.com.au [203.108.14.246]) by trends.net (8.8.8/8.8.8) with ESMTP id WAA24914 for ; Thu, 22 Apr 1999 22:32:57 -0400 (EDT) Received: from bigfoot.com (localhost [127.0.0.1]) by localhost.localdomain (8.8.7/8.8.7) with ESMTP id MAA00707 for ; Fri, 23 Apr 1999 12:34:34 +1000 Sender: chris@localhost.localdomain Message-ID: <371FDC3A.5A8BA9FF@bigfoot.com> Date: Fri, 23 Apr 1999 02:34:34 +0000 From: Chris Bitmead X-Mailer: Mozilla 4.51 [en] (X11; I; Linux 2.0.36 i686) X-Accept-Language: en MIME-Version: 1.0 To: pgsql-sql@hub.org Subject: Re: [SQL] SELECT TOP _x_ ?? References: <000401be8ccd$06c7e320$0a411a9f@cbn.org> <371F355F.7551BAAB@bigfoot.com> <372030FF.FCB6D1D4@prima.net.id> Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Chairudin Sentosa wrote: > > I tried this, did not work. > > ibs=> select * from ibs_subscriber limit 5; > ERROR: parser: syntax error at or near "5" > > Regards, > Chai > > PS: PostgreSQL 6.5 Which snapshot? > > Chris Bitmead wrote: > > > Justin Long wrote: > > > > > > In Microsoft SQL Server you could issue a command > > > > > > SELECT TOP 5 * FROM database... > > > > SELECT * FROM TABLE LIMIT 5; > > > > You may have to be running 6.5, not sure. > > > > -- > > Chris Bitmead > > http://www.bigfoot.com/~chris.bitmead > > mailto:chris.bitmead@bigfoot.com