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@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
	--------------------------------------------------------------------