Re: postgres subfunction return error - Mailing list pgsql-sql

Thank you!

What kind of variable would I declare? Is this any form of right?

No change to subfunction.

In PARENT Function:

DECLARE v_outvar1 REFCURSOR; v_outvar2 REFCURSOR; v_outvar3 REFCURSOR;

?And use:

SELECT * INTO v_outvar1, v_outvar2, v_outvar3 FROM dev.pr_test_subfunction(SWV_Action);

OPEN swv_refcur    for SELECT v_outvar1;

OPEN swv_refcur2 for SELECT v_outvar2;

OPEN swv_refcur3 for SELECT v_outvar3;

jonathansfl wrote

greetings. I'm trying to write a function that acts like a switchboard, calling other functions depending on incoming parameters.
I'm getting error: query has no destination for result data


    SELECT * FROM dev.pr_test_subfunction(SWV_Action);

In pl/pgsql if you do not use an "INTO" clause on a select statement you must replace the "SELECT" with "PERFORM".  Failing to do so results in the error you are seeing.  In this case your calls to the sub-function do not magically populate the parent function variables.  You must manually map the output of the sub-function call query onto the parent variables.

David J.