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.
signature.asc
Description: This is a digitally signed message part