refursor from dynamic query

Hi all,

just subscribed to the list - I've been writing my first
function/stored procedure and I've hit a bit of a problem. I'm
trying to build a dynamic query, then execute it but I need to
return a refcursor containing the records the dynamic query finds.
My code is below - I'd appreciate it if anyone could point me in
the right direction....

CREATE FUNCTION poptions (INTEGER)
RETURNS REFCURSOR AS '
DECLARE
-- parameters
p_author_id ALIAS FOR $1;

-- local variables
rc REFCURSOR;
row_data poem_option_def%ROWTYPE;
qString varchar(4000);

BEGIN
qString := ''SELECT p.poem_id,p.poem_title'';

FOR row_data IN SELECT option_id,option_name FROM poem_option_def LOOP
qString := qString || '', (SELECT po.setting FROM poem_option po WHERE po.poem_id = p.poem_id and po.option_id = '' || row_data.option_id || '') AS '' || row_data.option_name;
END LOOP;

qString := qString || '' FROM poem p WHERE p.author_id = '' || p_author_id;

OPEN rc FOR EXECUTE qString;

RETURN rc;
end;
' LANGUAGE 'plpgsql';

cheers,
Toby

---------------------------------------

Life is poetry - write it in your own words.

---------------------------------------

Toby Tremayne
Senior Technical Consultant
Code Poet and Zen Master of the Heavy Sleep
Lyricist Software
www.lyricist.com.au
0416 048 090
ICQ: 13107913