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. + ---------------------------(end of broadcast)--------------------------- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
