Re: [GENERAL] LIMIT QUESTION

[Chris Bitmead]

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