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 FOR loop is a plpgsql block not an SQL one. You'll need to write a plpgsql
function if you want to use it.
--
Richard Huxton
Archonet Ltd