FOR : Structure control pb

From: "Guillaume Houssay" <ghoussay(at)noos(dot)fr>
To: <pgsql-sql(at)postgresql(dot)org>
Subject: FOR : Structure control pb
Date: 2003-11-10 11:24:55
Message-ID: 00a201c3a77d$4457c820$eeac84c3@camille
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Christoph Haller 2003-11-10 11:37:15 Re: Dynamic Query for System functions - now()
Previous Message Guillaume Houssay 2003-11-10 11:18:32 FOR : control structure