[SQL] 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 proce

Re: [SQL] Need to Iterate the record in plpgsql

Hello http://okbob.blogspot.cz/2010/12/iteration-over-record-in-plpgsql.html http://postgres.cz/wiki/PostgreSQL_SQL_Tricks#Iteration_over_RECORD_variable_inside_trigger Regards Pavel Stehule 2012/8/31 Yelai, Ramkumar IN BLR STS : > Hi All, > > I am facing a issue in Iterating the RECORD. > > Th