Yep.. i have solved this problem by specifying the correct return type and variable type (should be the same)
but as said, in some cases pl_exec executes with type conversion. as real example - i have :
return type = SETOF new type "category_node(catid, pcatid)" variable = R, SR -> RECORD
and
FOR R IN select * from ... LOOP RETURN NEXT R; /* add RECORD to SETOF_of_CATEGORY_NODE */ ....
and works...
the problem seems is teh same - on altered tables there is some porblem with this :)
Actualy - return type & variable in "RETURN NEXT" must be the same type.
// Solved
John DeSoi wrote:
On Mar 11, 2005, at 5:54 AM, Juris Zeltins wrote:
FOR P IN select pageid from pages
This way you are only getting the pageid column. I think what you want is
FOR P in select * from pages
so that P contains the complete pages record.
John DeSoi, Ph.D. http://pgedit.com/ Power Tools for PostgreSQL
---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
