> Bruce Momjian <maillist(at)candle(dot)pha(dot)pa(dot)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...
Informix uses the following syntax, but does not have the offset feature:
select first 100 * from table ....
Andreas