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