Re: Multiple "selects" returned from a single stored procedure

Shachar Shemesh wrote:
> Just out of curiosity, how do I manually destroy the cursor when it's no 
> longer needed? Just do "close refcursor"?

Yup:

http://www.postgresql.org/docs/current/static/sql-close.html

> Also, does this copy take place when the table is changed, or as soon as 
> the transaction ends? If the former, it may not matter.

IIRC it is the latter.

Joe