On Sat, Apr 15, 2006 at 06:44:29PM -0400, Hrishikesh Deshmukh wrote: > I have a question about selecting rows, my table has 20,000 rows, i want to > look at rows 5000 to 10,000. See OFFSET and LIMIT in the SELECT documentation. Be sure to read the advice about using ORDER BY. http://www.postgresql.org/docs/8.1/interactive/sql-select.html#SQL-LIMIT -- Michael Fuhr