On Jul 26, 2009, at 6:46 PM, David E. Wheeler wrote:
> Is there some way to get using_while() to properly return all the
> records?
I'm just a random lurker, but FOUND seems to work just fine (I suppose
it's PG-specific?).
http://www.postgresql.org/docs/8.1/static/plpgsql-statements.html#PLPGSQL-STATEMENTS-DIAGNOSTICS
BEGIN OPEN stuff; FETCH stuff INTO rec; WHILE FOUND LOOP RETURN NEXT rec; FETCH stuff INTO rec; END
LOOP;
END;
HTH,
eric
