FOR : control structure

From: "Guillaume Houssay" <ghoussay(at)noos(dot)fr>
To: <pgsql-sql(at)postgresql(dot)org>
Subject: FOR : control structure
Date: 2003-11-10 11:18:32
Message-ID: 008301c3a77c$606ec000$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

Browse pgsql-sql by date

  From Date Subject
Next Message Guillaume Houssay 2003-11-10 11:24:55 FOR : Structure control pb
Previous Message Kumar 2003-11-10 07:12:47 Dynamic Query for System functions - now()