PL/pgSQL Return statements

From: "Donald Fraser" <postgres(at)kiwi-fraser(dot)net>
To: "[ADMIN]" <pgsql-admin(at)postgresql(dot)org>
Subject: PL/pgSQL Return statements
Date: 2007-01-15 17:13:45
Message-ID: 002501c738c8$876a1700$6364a8c0@DonAcer
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hello,
I am currently trying to upgrade PostgreSQL from 8.0 to 8.1 on our development machine and have run into a problem with RETURN VOID; statements in PL/pgSQL functions that have a return type of void.
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?

I did a pg_dumpall using the 8.1 libraries on the 8.0 database and this made no difference.

Thanks in advance,
regards
Donald Fraser

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Federico 2007-01-15 17:24:19 PostgreSQL data dir on linux raid software
Previous Message Tom Lane 2007-01-15 15:39:18 Re: Pg_dump behaviour