Thanks for your answer. In fact, I had a syntax error in my function. Sorry about that!
-----Message d'origine----- De : Tom Lane [mailto:[EMAIL PROTECTED] Envoyé : vendredi 1 octobre 2004 16:47 À : Johann Robette Cc : [EMAIL PROTECTED] Objet : Re: [HACKERS] Record unassigned yet "Johann Robette" <[EMAIL PROTECTED]> 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 ---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings
