I think I answered my own question: wait for 10.4 and use a table function. Any idea on when 10.4 is likely to roll out?
> I am attempting to use the output of a function or procedure in place of > the list of values or table subquery of an IN expression eg 'SELECT * > FROM TEST WHERE ID IN (TEST.MY_PROC(?))'.