Thread: BUG #18605: cursor select not working

BUG #18605: cursor select not working

From
PG Bug reporting form
Date:
The following bug has been logged on the website:

Bug reference:      18605
Logged by:          ANNADURAI s
Email address:      annadurai02145@outlook.com
PostgreSQL version: 15.5
Operating system:   pg admin  tool
Description:

BEGIN;
DECLARE 
 my_cursor CURSOR FOR SELECT * FROM example;
FETCH all FROM my_cursor;-------------------i have execute the script get
record row 

BEGIN;
DECLARE 
 my_cursor CURSOR FOR SELECT * FROM example;
FETCH all FROM my_cursor;
end;-----------this script execute no row found we need clarification 

------------------------------------------------------------------------------------------------------
i have create select procedure return cursor output execute this one
unammend port1 error showing we need clarification this one also