Re: When is a record NULL?

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