Content-Type: text/plain;
	charset=us-ascii
Mime-Version: 1.0 (Mac OS X Mail 13.4 \(3608.120.23.2.4\))
Subject: Re: How to return multiple rows by stored procedure in postgresql
From: =?utf-8?Q?Paul_F=C3=B6rster?= <paul.foerster@gmail.com>
In-Reply-To: 
 <CAN+uLsEvZH1JdhDUfJaevz8AUyVgdX75ufnc0TgUZY9wquKaOg@mail.gmail.com>
Date: Tue, 6 Oct 2020 08:40:20 +0200
Cc: androxkentaki <androxkentaki@gmail.com>,
 pgsql-admin <pgsql-admin@postgresql.org>
Content-Transfer-Encoding: quoted-printable
Message-Id: <39B3366A-5C16-4477-9C5C-03D3689179CB@gmail.com>
References: 
 <CAN+uLsG8ws_o8HtnZtvezte_74QQsT5qCs=1+fa+rY7ubv8HZw@mail.gmail.com>
 <CAL+gpC8FRukDicarW282TVd3_guZKW-Zbq8uw0xCObPovw+pcA@mail.gmail.com>
 <CAN+uLsEvZH1JdhDUfJaevz8AUyVgdX75ufnc0TgUZY9wquKaOg@mail.gmail.com>
To: Naveen Kumar <naveenmcp@gmail.com>
Precedence: bulk

Hi Naveen,

> On 06. Oct, 2020, at 08:15, Naveen Kumar <naveenmcp@gmail.com> wrote:
>=20
> Thank you for the quick response.
>=20
> 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.
>=20
> 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=