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
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
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
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