Home > mailing lists

FOR : Structure control pb - Mailing list pgsql-sql

From	Guillaume Houssay
Subject	FOR : Structure control pb
Date	November 10, 2003 10:12:34
Msg-id	00a201c3a77d$4457c820$eeac84c3@camille Whole thread Raw
Responses	Re: FOR : Structure control pb
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

From: Christoph Haller
Date: 10 November 2003, 09:37:56
Subject: Re: Dynamic Query for System functions - now()

From: "Kumar"
Date: 10 November 2003, 11:00:16
Subject: Re: Dynamic Query for System functions - now()