Re: [HACKERS] SELECT ... LIMIT (trial implementation)
Tom Lane <tgl@sss.pgh.pa.us>
From: Tom Lane <tgl@sss.pgh.pa.us>
To: Bruce Momjian <maillist@candle.pha.pa.us>
Cc: pgsql-hackers@postgreSQL.org
Date: 1998-10-18T16:04:49Z
Lists: pgsql-hackers
Bruce Momjian <maillist@candle.pha.pa.us> writes: > What if someone wants the rows from 500 to the end. Should we allow > the syntax to be: > SELECT ... [LIMIT count] [OFFSET offset] > LIMIT and OFFSET are independent. I like that syntax the best, but remember we are not inventing in a green field here. Isn't this a feature that already exists in other DBMs? We should probably copy their syntax, unless it's truly spectacularly awful... regards, tom lane