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
On Fri, Dec 16, 2005 at 07:14:42PM -0500, Bruce Momjian wrote:
> 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.
Either interesting or a great way to introduce bugs... AFAIK
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
> ther
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 ne
