Wilton wrote:
      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

Reply via email to