I have one procedure which has 4 input parameter as refcursor and they are as INOUT parameter.
Now, I want to call that procedure in begin end; block and want to display those 4 refcursor result in pgadmin. I tried multiple option like unnamed portal, declare a refcursor and use in fetch all from..into...etc. But, no option is showing result.
Please help if there is some solution for this, I tried all option available in sites but it did not worked.
I am not sure if i understood it correctly. you have a refcursor as param in a procedure where you initialize and return a refcursor.
postgres=# create procedure p1 (INOUT r1 refcursor) as $$
begin
open r1 for select id from dates;
return;
end; $$ language plpgsql;
CREATE PROCEDURE
-- you would need a do block to declare vars as this would be plpgsql
From:
Thorsten Schöning Date: Subject:
What's the dfifference between pg_start_backup+copy+pg_stop_backup+WAL vs. pg_start_backup+pg_stop_backup+copy+WAL?
Есть вопросы? Напишите нам!
Соглашаюсь с условиями обработки персональных данных
✖
By continuing to browse this website, you agree to the use of cookies. Go to Privacy Policy.