RE: [GENERAL] LIMIT QUESTION

[Michael J Davis]

I think "limit" is new with version 6.5.

        -----Original Message-----
        From:   Martin Wong [SMTP:[EMAIL PROTECTED]]
        Sent:   Wednesday, April 28, 1999 8:07 PM
        To:     [EMAIL PROTECTED]
        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