Re: Problem with FOR LOOP query - Mailing list pgsql-novice

"Greg Quinn" <greg@officium.co.za> writes:
> In my function I am trying to declare a variable of type RECORD.
> DECLARE curRecord RECORD;
> But it gives an error.

Worksforme.  You really need to provide a complete example and the
specific error you're getting if you want useful help.

> It also doesn't like my FOR LOOP

> FOR curRecord IN SELECT messageid from email_inbox where folderid = $1 LOOP
>     EXECUTE sp_deleteemailinboxmessagetodeleteditems(curRecord.messageid);
> LOOP;

I think the problem is the last line has to be END LOOP; ... though
again the specific text of the error would have made diagnosis a lot
more certain.

            regards, tom lane