RE: [GENERAL] limit select question - Mailing list pgsql-general

From Kevin Heflin
Subject RE: [GENERAL] limit select question
Date
Msg-id Pine.LNX.4.04.9903310124310.8082-100000@mercury.shreve.net
Whole thread Raw
In response to RE: [GENERAL] limit select question  (Michael Davis <michael.davis@prevuenet.com>)
List pgsql-general
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
--------------------------------------------------------------------


pgsql-general by date:

Previous
From: Michael Davis
Date:
Subject: RE: [GENERAL] limit select question
Next
From: Michael Davis
Date:
Subject: RE: [GENERAL] limit select question