Need to Iterate the record in plpgsql - Mailing list pgsql-sql

From Yelai, Ramkumar IN BLR STS
Subject Need to Iterate the record in plpgsql
Date
Msg-id 13D0F6C9B3073A4999E61CAAD61AE7ECC45265BA99@INBLRK77M2MSX.in002.siemens.net
Whole thread Raw
Responses Re: Need to Iterate the record in plpgsql
Re: Need to Iterate the record in plpgsql
List pgsql-sql
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
 
 
 
 
 

pgsql-sql by date:

Previous
From: David Johnston
Date:
Subject: Re: prepared statement in crosstab query
Next
From: Pavel Stehule
Date:
Subject: Re: Need to Iterate the record in plpgsql