limiting the rows selected in postgresql

how can i limit the number of rows obtained from a select statement
in postgreSQL to say, 10 rows while the select condition  actually
matches more than that. in oracle we can use the ROW_NUM variable
for this purpose but now i met such an issue with postgreSQL

thanks in advance

CV Radhakrishnan

http://www.river-valley.com