Re: [GENERAL] Question about selecting rows

2006-04-15 Thread Michael Fuhr
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.postgres

Re: [GENERAL] Question about selecting rows

2006-04-15 Thread Douglas McNaught
"Hrishikesh Deshmukh" <[EMAIL PROTECTED]> writes: > Hi All, > > I have a question about selecting rows, my table has 20,000 rows, i want to > look at rows 5000 to 10,000. There is no defined row ordering in SQL unless you use ORDER BY, so you need to specify how you want to sort it first. > How