"The tuple structure of a not-yet-assigned record is indeterminate."

From: "A B" <gentosaker(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: "The tuple structure of a not-yet-assigned record is indeterminate."
Date: 2008-06-30 11:33:55
Message-ID: dbbf25900806300433y2d92521bp446b49c2129aed39@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

In my function I have (kept the important part)

CREATE OR REPLACE FUNCTION foo() RETURNS SETOF RECORD AS $$
DECLARE
retval RECORD;
BEGIN
some loop
retval.jd := tmp.id;
retval.d2 := _c2;
retval.d3 := _c3;
RETURN NEXT retval;
end loop
return;
END;

and I get

ERROR: record "retval" is not assigned yet
DETAIL: The tuple structure of a not-yet-assigned record is indeterminate.
CONTEXT: PL/pgSQL function "foo" line 33 at assignment

It seems that the line with retval.jd := tmp.id; is where it stops.
Any suggestion on how to fix this error?

Responses

Browse pgsql-general by date

  From Date Subject
Next Message A. Kretschmer 2008-06-30 11:46:39 Re: "The tuple structure of a not-yet-assigned record is indeterminate."
Previous Message A B 2008-06-30 11:06:59 Re: allowed variable names in functions?