Re: [SQL] SELECT TOP _x_ ?? - Mailing list pgsql-sql

I tried this, did not work.

ibs=> select * from ibs_subscriber limit 5;
ERROR:  parser: syntax error at or near "5"

Regards,
Chai

PS: PostgreSQL 6.5 snapshot.

Chris Bitmead wrote:

> Justin Long wrote:
> >
> > In Microsoft SQL Server you could issue a command
> >
> >         SELECT TOP 5 * FROM database...
>
> SELECT * FROM TABLE LIMIT 5;
>
> You may have to be running 6.5, not sure.
>
> --
> Chris Bitmead
> http://www.bigfoot.com/~chris.bitmead
> mailto:chris.bitmead@bigfoot.com