Home > database >  Postgresql in stored procedure how to return a set of data?
Postgresql in stored procedure how to return a set of data?

Time:03-16

The stored procedure in the postgresql (procedure is not function) how to return a set of data?
I wrote the following such complains.
 
The CREATE OR REPLACE PROCEDURE getlist ()
AS $BODY $
The begin
Select * from the actor;
end;
$BODY $
LANGUAGE PLPGSQL

How to modify the correct? Thank you very much!

  • Related