1
Answer

How to return multi tables in postgres without refcursor?

souvik sardar

souvik sardar

6y
742
1
I have one procedure in sql server like:::
 
creare roc sp_fetch()
as
begin
select id,name from Tbl_User;
select projectId, projectname from Tbl_project
end; 
 
How to write the same query in postgres function without using refcursor? How to return multi result set from function?
Answers (1)