Hi Naveen,
> On 06. Oct, 2020, at 08:15, Naveen Kumar <naveenmcp@gmail.com> 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
returnmultiple 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