Thanks for the catch.  

However, this did not fix the syntax error.

-----Original Message-----
From: Adrian Klaver [mailto:adrian.kla...@gmail.com] 
Sent: Wednesday, January 27, 2010 11:47 AM
To: Aycock, Jeff R.
Cc: Pavel Stehule; pgsql-general@postgresql.org
Subject: Re: [GENERAL] syntax error during function call

On 01/27/2010 08:41 AM, Aycock, Jeff R. wrote:
> Adrian,
>
> I tried that as well and got the same error result.
>
> Regards,
> Jeff Aycock
>
>

I went back to the original function and assuming no cut/paste errors 
there is a ';' missing after the last END.

             END;

         RETURN NEXT r;

     END LOOP;

     RETURN;

END

$BODY$

LANGUAGE 'plpgsql' ;


-- 
Adrian Klaver
adrian.kla...@gmail.com

-- 
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

Reply via email to