RE: [GENERAL] limit select question

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(at)shreve(dot)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(at)shreve(dot)net | Shreveport, LA 71101 | http://www.shreve.net
--------------------------------------------------------------------