hi, i have posgresql 6.4 and jdbc6.4. i am making a query returning like 6000 registers. I would like to restrict the query in order to show the result 100 by 100 registers. how can i make that SQL query? if i make " select * from files order by (name)"; thanks in advance, marcos -- m a r c o s @ i v a l . e s