Re: Negative offsets

Bruce Momjian wrote:
> CSN wrote:
> > I was playing around with negative offsets:
> >
> > select * from table1 order by col1 offset -5 limit 25;
> > select * from table1 order by col1 offset -25 limit
> > 25;
> > select * from table1 order by col1 offset -250 limit
> > 25;
> >
> > They all return the same resultset (offset 0). Is
> > there even any point in allowing negative offsets -
> > such as maybe someday they'll offset backwards?
>
> Actually we allow negative offsets and limits. Seems we should disallow
> them. Yes, it would be interesting if they did offsets relative to the
> end of the result set.

Seems most people just want to leave our current behavior unchanged.

--
Bruce Momjian http://candle.pha.pa.us
SRA OSS, Inc. http://www.sraoss.com

+ If your life is a hard drive, Christ can be your backup. +