Chris Bitmead ha scritto:
> 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
Use SET QUERY_LIMT TO 10;
this should work in 6.4.2
______________________________________________________________
PostgreSQL 6.5.0 on i586-pc-linux-gnu, compiled by gcc 2.7.2.3
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
Jose'