0

I am trying to create a stored procedure in postgresql which will return multiple rows from a table/result set from a join between multiple tables. When I am trying to execute the procedure I am getting an error 'Query has no destination for result data'. I am simplifying my procedure with the below example. postgresql version --> 14.X

create or replace procedure sample()
language plpgsql
as $$
begin
select col1,col2,col3,col4 from tablename;
end;
$$

--call sample()
The Impaler
  • 38,638
  • 7
  • 30
  • 65
subhrendu
  • 139
  • 1
  • 1
  • 15

0 Answers0