Re: PL/pgSQL Return statements

[Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>]

"Donald Fraser" <postgres(at)kiwi-fraser(dot)net> writes:
> I'm getting errors like the following:

> ERROR:  RETURN cannot have a parameter in function returning void at or =
> near "VOID" at character 2983.

> Does this mean I must edit every function that is declared with RETURNS =
> VOID and remove the RETURN VOID; statement from the body?

Yup.  That was never correct code, but plpgsql used to completely ignore
anything after RETURN in a function declared to return VOID.  Which
surprised enough people that we changed it ...

			regards, tom lane