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@xxxxxxxxxxx