Only PostgreSQL 6.5 Beta supports LIMIT.
> 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