[GENERAL] LIMIT QUESTION

[Martin Wong]

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