[SQL] Need to Iterate the record in plpgsql

[Yelai, Ramkumar IN BLR STS]

Hi All,

I am facing a issue in Iterating the RECORD.

The problem is, I would like to iterate the RECORD without using sql query, but 
as per the syntax I have to use query as shown below.

FOR target IN query LOOP
    statements
END LOOP [ label ];

In my procedure, I have stored one of the procedure output as record, which I 
am later using in another iteration. Below is the example


CREATE OR REPLACE FUNCTION test2()

Rec1 RECORD;
Rec2 RECORD;
Rec3 RECORD;

SELECT * INTO REC1 FROM test();

FOR REC2 IN ( select * from test3())
LOOP
        FOR REC3 IN REC2 --- this syntax does not allowed by Postgresql
        LOOP

        END LOOP
END LOOP

As per the example, How can I iterate pre stored record.

Please let me know if you have any suggestions.

Thanks & Regards,
Ramkumar