RE: [GENERAL] limit select question

From: Kevin Heflin <kheflin(at)shreve(dot)net>
To: Michael Davis <michael(dot)davis(at)prevuenet(dot)com>
Cc: "PGSQL-General (E-mail)" <pgsql-general(at)postgreSQL(dot)org>
Subject: RE: [GENERAL] limit select question
Date: 1999-03-31 07:26:21
Message-ID: Pine.LNX.4.04.9903310124310.8082-100000@mercury.shreve.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)shreve(dot)net | Shreveport, LA 71101 | http://www.shreve.net
--------------------------------------------------------------------

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Kevin Heflin 1999-03-31 07:30:25 RE: [GENERAL] limit select question
Previous Message Michael Davis 1999-03-31 07:20:52 RE: [GENERAL] limit select question