StrCampo = ''new.'' || qCampos.attname; StrInsert = StrInsert || virgula || StrCampo || '' - ''; End Loop;
Return new; End;
What i need to do for the variable StrCampo returns to me "SP", "RJ", i mean, return a value inserted into the field.
I do not want to use static command new.campo1, new.campo2....
Ah - you can't. Not in plpgsql, anyway. You should perhaps look at pltcl or plperl.
-- Richard Huxton Archonet Ltd
---------------------------(end of broadcast)--------------------------- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match