Re: [SQL] FOR : Structure control pb

2003-11-10 Thread Richard Huxton
On Monday 10 November 2003 11:24, Guillaume Houssay wrote: > 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. The F

[SQL] FOR : Structure control pb

2003-11-10 Thread Guillaume Houssay
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 us