Re: integer ceiling in LIMIT and OFFSET

On Wed, 2003-10-22 at 10:22, Christopher Kings-Lynne wrote:
> > I see you're point, but nobody is going to be interested in the first 2
> > billion rows of a table without using a cursor and having some other
> > process do the math in the background.
>
> You have the same problem:

> test=# move 2147483648 in c;
> ERROR:  syntax error at or near "2147483648" at character 6

You're simply not going to be interested in doing this. Fetching rows in
blocks of 1 million for processing is probably the highest sane maximum.

Now, if we have a problem with a cursor doing 1 million loops pulling 1
million rows each iteration then we have a problem.