Re: syntax error during function call - Mailing list pgsql-general

From Aycock, Jeff R.
Subject Re: syntax error during function call
Date
Msg-id 65151B9A7C8C9C4284ABC85F0336DE5003972E1C@0015-its-exmb11.us.saic.com
Whole thread Raw
In response to Re: syntax error during function call  (Adrian Klaver <adrian.klaver@gmail.com>)
Responses Re: syntax error during function call  (Adrian Klaver <adrian.klaver@gmail.com>)
Re: syntax error during function call  (Adrian Klaver <adrian.klaver@gmail.com>)
List pgsql-general
Thanks for the catch.

However, this did not fix the syntax error.

-----Original Message-----
From: Adrian Klaver [mailto:adrian.klaver@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.klaver@gmail.com

pgsql-general by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: syntax error during function call
Next
From: Adrian Klaver
Date:
Subject: Re: syntax error during function call