souvik sardar

souvik sardar

  • 1.8k
  • 65
  • 242

How to return multi tables in postgres without refcursor?

Apr 24 2018 12:39 PM
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)