Thread: FOR : control structure

FOR : control structure

From
"Guillaume Houssay"
Date:
I am using the For controle structure as follows
 
FOR i IN 0..23 LOOP
 
query
 
END LOOP;
 
The query is tested and is working OK.
 
When I launch the loop in psql interface, I get the error parse error at or near FOR.
 
As this is the first time I use this kind of struture I am probably using it the wrong way.
 
Thank you for your answer