Re: How to return multiple rows by stored procedure in postgresql

[Naveen Kumar <naveenmcp@xxxxxxxxx>]

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

On Tue, Oct 6, 2020 at 11:32 AM androxkentaki <androxkentaki@xxxxxxxxx> wrote:

1 minute research in google

https://www.google.com/search?client=firefox-b-d&q=postgresql+select+form+procedure

https://stackoverflow.com/questions/11740256/refactor-a-pl-pgsql-function-to-return-the-output-of-various-select-queries/11751557#11751557

wt., 6 paź 2020 o 07:55 Naveen Kumar <naveenmcp@xxxxxxxxx> napisał(a):

can someone please help me on How to return multiple rows by stored procedure in postgresql? if possible with an example?

Thank you

Naveen

--

Z wyrazami szacunku
Andrzej Gerasimuk