Talk About Network

Google


Register and Login
Nick
Password
Register create new account Sign up is FREE and you can post replies, new topics, bookmark posts and more!
Recover lost password


Data Bases > Pgsql General > "The tuple stru...
Latest [ Topics | Posts ] Archive Post A New Topic Post a Reply
<< Topic < Post Post 1 of 8 Topic 15933 of 17437
Post > Topic >>

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

by gentosaker@[EMAIL PROTECTED] ("A B") Jun 30, 2008 at 01:33 PM

In my function I have (kept the im****tant 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?

-- 
Sent via pgsql-general mailing list (pgsql-general@[EMAIL PROTECTED]
)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
 




 8 Posts in Topic:
"The tuple structure of a not-yet-assigned record is indetermina
gentosaker@[EMAIL PROTECT  2008-06-30 13:33:55 
Re: "The tuple structure of a not-yet-assigned record is indeter
andreas.kretschmer@[EMAIL  2008-06-30 13:46:39 
Re: "The tuple structure of a not-yet-assigned record is indeter
gentosaker@[EMAIL PROTECT  2008-06-30 13:57:22 
Re: "The tuple structure of a not-yet-assigned record is indeter
andreas.kretschmer@[EMAIL  2008-06-30 14:03:49 
Re: "The tuple structure of a not-yet-assigned record is indeter
gentosaker@[EMAIL PROTECT  2008-06-30 14:25:30 
Re: "The tuple structure of a not-yet-assigned record is indeter
andreas.kretschmer@[EMAIL  2008-06-30 14:39:17 
Re: "The tuple structure of a not-yet-assigned record is indeter
gentosaker@[EMAIL PROTECT  2008-06-30 16:47:22 
Re: "The tuple structure of a not-yet-assigned record is indeter
gentosaker@[EMAIL PROTECT  2008-06-30 17:48:58 

Post A Reply:
  Go here to Signup

AddThis Feed Button


About - Advertising - Contact - Frequently Asked Questions - Privacy Policy - Terms of Use - Signup

Contact
tan12V112 Sat Nov 22 16:38:40 CST 2008.