Thread

  1. RE: [GENERAL] limit select question

    Kevin Heflin <kheflin@shreve.net> — 1999-03-31T07:30:25Z

    On Wed, 31 Mar 1999, Michael Davis wrote:
    
    > 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.
    
    Is version 6.5 to be had some where, or is it only in beta?
    
    I sure could use that feature on a project I'm working on right now...
    
    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
    --------------------------------------------------------------------
    
    
    
  2. RE: [GENERAL] limit select question

    Michael Davis <michael.davis@prevuenet.com> — 1999-03-31T07:32:42Z

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