plpgsql function changes? - Mailing list pgsql-general

From David Lazar
Subject plpgsql function changes?
Date
Msg-id 42BDC436.8080909@resistorsoftware.com
Whole thread Raw
Responses Re: plpgsql function changes?
List pgsql-general
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!!



pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Postmaster Out of Memory
Next
From: Tom Lane
Date:
Subject: Re: plpgsql function changes?