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

From jonathansfl
Subject Re: postgres subfunction return error
Date
Msg-id 008201ceba47$91fbb680$b5f32380$@com
Whole thread Raw
In response to Re: postgres subfunction return error  (David Johnston <polobo@yahoo.com>)
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;

 

 

From: David Johnston [via PostgreSQL] [mailto:[hidden email]]
Sent: Wednesday, September 25, 2013 7:19 PM
To: jonathansfl
Subject: Re: postgres subfunction return error

 

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.


If you reply to this email, your message will be added to the discussion below:

click here.
NAML



View this message in context: RE: postgres subfunction return error
Sent from the PostgreSQL - sql mailing list archive at Nabble.com.

pgsql-sql by date:

Previous
From: David Johnston
Date:
Subject: Re: postgres subfunction return error
Next
From: jonathansfl
Date:
Subject: Re: postgres subfunction return error