Anyone know the most efficient way of FETCHing a batch of rows, and
looping >> through them in a function? FETCHing a record at a
time will work, but I >> was wondering whether this could be done.
You're outsmarting yourself.
:-) One can only try.
plpgsql already does the equivalent of
"Henry Combrinck" <[EMAIL PROTECTED]> writes:
> Anyone know the most efficient way of FETCHing a batch of rows, and
> looping through them in a function? FETCHing a record at a time will
> work, but I was wondering whether this could be done.
You're outsmarting yourself. plpgsql already does
Greetings,
I gather the following isn't possible (which would have been elegant
and ideal):
FOR rec IN
FETCH 10 FROM cursor
LOOP
...
Anyone know the most efficient way of FETCHing a batch of rows, and
looping through them in a function? FETCHing a record at a time will
work, bu
