plpgsql function changes?

From: David Lazar <dlazar(at)resistorsoftware(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: plpgsql function changes?
Date: 2005-06-25 20:53:10
Message-ID: 42BDC436.8080909@resistorsoftware.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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!!

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2005-06-25 21:42:50 Re: plpgsql function changes?
Previous Message Marek Aleksander Dąbek 2005-06-25 18:40:44 Windows XP installation problem