Обсуждение: plpgsql function changes?

Hi,

I run a function that returns a setof custom type rows against pgsql
7.4.6 and it works great. The same type and function was migrated to
pgsql 8.0.3 but fails to run, returning an error:

ERROR: RETURN cannot have a parameter in function returning set; use
RETURN NEXT at or near "pkg" at character 1149

where pkg is just a declared RECORD variable.

Did something change from pgsql 7.X series set returning function to
version 8.X series???

I am thinking no... and that maybe the migration of code using
pg_restore screwed something up... any tips??

Thanks!!

David Lazar <dlazar@resistorsoftware.com> writes:
> ERROR: RETURN cannot have a parameter in function returning set; use
> RETURN NEXT at or near "pkg" at character 1149

> Did something change from pgsql 7.X series set returning function to
> version 8.X series???

I think 8.0 actually complains that you made a mistake, whereas 7.x
just silently ignores it.  It's still a mistake though.

            regards, tom lane