Hi Naveen, > On 06. Oct, 2020, at 08:15, Naveen Kumar <naveenmcp@xxxxxxxxx> wrote: > > Thank you for the quick response. > > All the examples are talking about functions, not about procedures in PostgreSQL. what i am looking for is how to return multiple rows by calling STORED PROCEDURE in postgreSQL 12 version. > > Thank you > Naveen a procedure does by definition not return anything. If you want to return something, use a function. As for returning multiple rows, use create function ... returns table (columns...) https://www.postgresql.org/docs/current/sql-createfunction.html https://www.postgresql.org/docs/current/sql-createprocedure.html Cheers, Paul
