Re: Negative offsets

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.

--
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073