Thread: RE: [GENERAL] limit select question

RE: [GENERAL] limit select question

From
Michael Davis
Date:
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
    --------------------------------------------------------------------

RE: [GENERAL] limit select question

From
Kevin Heflin
Date:
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
--------------------------------------------------------------------