Received: from ns1.prima.net.id ([202.57.0.8]) by hub.org (8.9.3/8.9.1) with ESMTP id WAA01089 for ; Thu, 22 Apr 1999 22:51:07 -0400 (EDT) (envelope-from chairudin@prima.net.id) Received: from prima.net.id (mail.prima.net.id [202.57.0.8]) by ns1.prima.net.id (8.8.4/8.7.2) with ESMTP id PAA10190; Fri, 23 Apr 1999 15:36:15 +0700 (GMT) Sender: root@ns1.prima.net.id Message-ID: <372030FF.FCB6D1D4@prima.net.id> Date: Fri, 23 Apr 1999 01:36:15 -0700 From: Chairudin Sentosa Reply-To: chairudin@prima.net.id Organization: PT. Khasanah Timur Indonesia X-Mailer: Mozilla 4.5 [en] (X11; I; SunOS 5.5.1 sun4u) X-Accept-Language: en MIME-Version: 1.0 To: Chris Bitmead CC: pgsql-sql@hub.org Subject: Re: [SQL] SELECT TOP _x_ ?? References: <000401be8ccd$06c7e320$0a411a9f@cbn.org> <371F355F.7551BAAB@bigfoot.com> Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit 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 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