I tried this, did not work.
ibs=> select * from ibs_subscriber limit 5;
ERROR: parser: syntax error at or near "5"
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
In response to
pgsql-sql by date
|Next:||From: Chairudin Sentosa||Date: 1999-04-23 09:13:12|
|Subject: Re: [INTERFACES] where did that date and time come from??|
|Previous:||From: Chairudin Sentosa||Date: 1999-04-23 08:34:42|
|Subject: Re: [SQL] Finding the "most recent" rows|