Thanks for your answer.
In fact, I had a syntax error in my function.
Sorry about that!
-----Message d'origine-----
De : Tom Lane [mailto:tgl@sss.pgh.pa.us]
Envoyé : vendredi 1 octobre 2004 16:47
À : Johann Robette
Cc : pgsql-hackers@postgresql.org
Objet : Re: [HACKERS] Record unassigned yet
"Johann Robette" <jrobette@onyme.com> writes:
> I've created a function with a FOR loop.
> DECLARE
> Current RECORD;
> BEGIN
> FOR current IN SELECT * FROM employees LOOP
> Tmp := current.id;
> END LOOP;
> ...
> When I call the function, I get the error :
> ERROR: record " current " is unassigned yet
> Any idea?
What you showed us looks fine, therefore the problem is in something you
didn't show us.
regards, tom lane
