[ic] select a specified number of records from a postgres table

[Jonathan Clark]

> hi.  i hope this is an easy question for someone.  i am trying to do the 
> equivalence of an Oracle ROWNUM or 
> a SQLServer TOP command with postgres and cannot figure it out.

In MySQL its LIMIT:

SELECT * FROM products LIMIT 5

to return 5 rows.

Jonathan
Webmaint.