On Fri, May 16, 2008 at 2:17 AM, Albe Laurenz <[EMAIL PROTECTED]> wrote: > Chuck Bai wrote: > CREATE OR REPLACE FUNCTION test_refcursor(INOUT tcount integer, > OUT o_user refcursor, OUT o_name refcursor) RETURNS record AS > $BODY$ > BEGIN > o_user := 'o_user'; > o_name := 'o_name'; > tcount := tcount + 1; > OPEN o_user FOR SELECT * FROM user_table; > OPEN o_name FOR SELECT * FROM name_table; > END; > $BODY$ > LANGUAGE 'plpgsql' VOLATILE
also don't forget, the refcursors are only valid for the duration of the transaction. merlin -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
