On 11/22/20 8:53 PM, Muthukumar.GK wrote:
> Hi Team,
>
> I have created function in postgre sql 13 which will return two result.
> But when execute i can able to see the last cursor (query result set of
> last select )result set in Data output window of Pgadmin4. i tried
> executing the cursor inside the transaction as well (BEING.....COMMIT).
> but i still do not see both result set one by one (likeSQL) in data
> output window. Please let me know if there is any limitation in pgadmin4
> tool that multiple result set will not be displayed in Data output Window.
From what I remember pgAdmin4 will only display the last result.
>
> Regards
> Muthukumar
--
Adrian Klaver
adrian.klaver@aklaver.com