Limit clause is not working in Postgresql7.0.2

  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