Re: Return void error in PG 8.1.0

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Walker, Jed S" <Jed_Walker(at)cable(dot)comcast(dot)com>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: Return void error in PG 8.1.0
Date: 2005-12-09 20:21:51
Message-ID: 1105.1134159711@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

"Walker, Jed S" <Jed_Walker(at)cable(dot)comcast(dot)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

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message Walker, Jed S 2005-12-09 20:27:58 Re: Return void error in PG 8.1.0
Previous Message Walker, Jed S 2005-12-09 19:56:11 Return void error in PG 8.1.0