RE: [GENERAL] LIMIT QUESTION - Mailing list pgsql-general

I think "limit" is new with version 6.5.

    -----Original Message-----
    From:    Martin Wong [SMTP:martin@minook.com.sg]
    Sent:    Wednesday, April 28, 1999 8:07 PM
    To:    pgsql-general@postgreSQL.org
    Subject:    [GENERAL] LIMIT QUESTION

    Hi,

    I've an elementary question. What's wrong with the following :

    dbtest=> select * from testusers limit 10;
    ERROR:  parser: parse error at or near "10"
    dbtest=> select version();
    version
    -------------------------------------------------------------
    PostgreSQL 6.4.2 on i586-pc-linux-gnu, compiled by gcc 2.7.2.
    (1 row)

    the testuser table has about 1000 rows.

    Please comment.

    Thanks