On Wed, 22 Oct 2003, Tom Lane wrote: > Rod Taylor <[EMAIL PROTECTED]> writes: > > That said, perhaps the TODO for changing LIMIT / OFFSET to be expression > > based should also mention bumping them to int8. > > Can't get excited about it ... this would slow down the normal use of > the facility for what seems a completely hypothetical need.
While I'm pretty sure select * from sometable limit 2147483648 isn't gonna be common, maybe someone would be likely to do something like: select * from sometable limit 10 offset 2147483648 I wouldn't do it, but who knows what shadows lurk in men's minds? ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html