Received: from bologna.nettuno.it (bologna.nettuno.it [193.43.2.1]) by hub.org (8.9.3/8.9.1) with ESMTP id KAA67663 for ; Fri, 23 Apr 1999 10:33:11 -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 QAA10081; Fri, 23 Apr 1999 16:33:01 +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 10aild-00004e-00; Fri, 23 Apr 1999 16:25:29 +0000 Message-ID: <372082EB.B7589C22@sferacarta.com> Date: Fri, 23 Apr 1999 16:25:47 +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: justinlong@xc.org CC: pgsql-sql@hub.org Subject: Re: [SQL] SELECT TOP X -- part 2 -- parse error? References: <000301be8cf1$4845e620$0a411a9f@cbn.org> Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit Justin Long ha scritto: > Thanks for the answers. I downloaded and installed PG5... now I have a new > problem. I can't seem to access any documentation on the syntax of the new > additions to PG5, and I'm getting a parse error with the following command > > SELECT * FROM database LIMIT 5 ^^^^^^^^ database ???? the right syntax is: SELECT * FROM table LIMIT 5 > > It says > > parse error at or near "5" > EXAMPLE: prova=> select * from test limit 1; v| c| i ---+---+--- 123|123|123 (1 row) José