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