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:[EMAIL PROTECTED]]
        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
        [EMAIL PROTECTED]    | Shreveport, LA 71101 | http://www.shreve.net
        --------------------------------------------------------------------

Reply via email to