Need to Iterate the record in plpgsql

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

 

        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