FOR : control structure - Mailing list pgsql-sql

From Guillaume Houssay
Subject FOR : control structure
Date
Msg-id 008301c3a77c$606ec000$eeac84c3@camille
Whole thread Raw
List pgsql-sql
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
 

pgsql-sql by date:

Previous
From: Yasir Malik
Date:
Subject: Re: help me...
Next
From: Jan Wieck
Date:
Subject: Re: transaction processing after error in statement