Re: [GENERAL] Negative offsets

2006-03-02 Thread Bruce Momjian
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

Re: [GENERAL] Negative offsets

2005-12-16 Thread Bruce Momjian
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

Re: [GENERAL] Negative offsets

2005-12-16 Thread Jim C. Nasby
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

[GENERAL] Negative offsets

2005-12-12 Thread CSN
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