We are testing our system using PG 8.1.0 instead of 8.0.4. When I
recreated functions I discovered that the ones that have "returns void"
and do return void all failed with the following error (when creating
them):

ERROR: RETURN cannot have a parameter in function returning void at or
near "void" at character 357

Is this a known issue or change to PG? Is there a way to still return
void in 8.1.0?

Any help would be appreciated in figuring this out.

Thanks,

Jed

"Walker, Jed S" <Jed_Walker@cable.comcast.com> writes:
> We are testing our system using PG 8.1.0 instead of 8.0.4. When I
> recreated functions I discovered that the ones that have "returns void"
> and do return void all failed with the following error (when creating
> them):

> ERROR: RETURN cannot have a parameter in function returning void at or
> near "void" at character 357

> Is this a known issue or change to PG? Is there a way to still return
> void in 8.1.0?

"return void" was never correct; the correct and documented thing is
just "return"; but older versions of plpgsql were laxer about complaining
about junk in a RETURN that should have no parameter.

regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster