Good point. I am running 6.5. So it has been fixed. I am not sure what
patch is needed to make this work on 6.4.2.
-----Original Message-----
From: Kevin Heflin [SMTP:kheflin@shreve.net]
Sent: Wednesday, March 31, 1999 12:26 AM
To: Michael Davis
Cc: PGSQL-General (E-mail)
Subject: RE: [GENERAL] limit select question
On Wed, 31 Mar 1999, Michael Davis wrote:
> Select * From table_name limit 1;
I'm running postgres6.4.2, and this query fails with:
ERROR: parser: parse error at or near "1"
I was told I could gain this feature by adding the 6.4.2 feature
patch.
But when I tried installing the patch, anything and everything I
tried in
psql failed with an error on 'select'
Kevin
--------------------------------------------------------------------
Kevin Heflin | ShreveNet, Inc. | Ph:318.222.2638 x103
VP/Mac Tech | 333 Texas St #619 | FAX:318.221.6612
kheflin@shreve.net | Shreveport, LA 71101 | http://www.shreve.net
--------------------------------------------------------------------