Limit clause is not working in Postgresql7.0.2

From: Ricky <weetat(at)cesma(dot)com(dot)sg>
To: pgsql-sql(at)postgresql(dot)org
Subject: Limit clause is not working in Postgresql7.0.2
Date: 2001-03-23 03:41:22
Message-ID: 3ABAC5E2.25156979@cesma.com.sg
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql


Hi all ,

I tried to do a select statement below :

select * from homeuser order userid
limit 5;

However it did not working ,it display all the records in the
database.
You all have any ideas how to use limit clause ??

Thanks weetat

Browse pgsql-sql by date

  From Date Subject
Next Message pgsql-sql 2001-03-23 07:15:02 trigger output to a file
Previous Message datactrl 2001-03-23 03:06:45 drop table in PL/pgSQL