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
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,
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 the