From: | "Muthukumar(dot)GK" <muthankumar(at)gmail(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Multiple result set not working |
Date: | 2020-11-19 12:04:16 |
Message-ID: | CA+rAWgkxreFz0vG1N4bVT0N7_hCZTdB2gLQOKrCKQ+cY3ssXAQ@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hi team,
is it possible to return Multiple results set from procedure/function on
single execution. Please advise me on this. I have written sample code
below and when i execute it i dont get any result set
CREATE OR REPLACE FUNCTION multiResultset(
ref1 refcursor,
ref2 refcursor)
RETURNS SETOF refcursor
AS $$
BEGIN
open ref1 for
select * from los_approverreassignwhere pk_id= 10;
open ref2 for
select * from los_approverreassignwhere pk_id= 11;
END;
$$
LANGUAGE 'plpgsql';
[image: image.png]
Regards
Muthu
From | Date | Subject | |
---|---|---|---|
Next Message | Daniel Verite | 2020-11-19 12:06:50 | Re: Multiple result set to be returned in procedure/function |
Previous Message | Simon Riggs | 2020-11-19 11:24:08 | Re: Performance degradation with non-null proconfig |