[SQL] Function Doubt

[Wilton]

Inside a function of trigger type, i have:
Declare
   qCampos record;
   StrCampo string;
   StrInsert string;
Begin
   StrCampo = '''';
   StrInsert = '''';
   For qCampos in select pga.attname from pg_class pgc, pg_attribute pga
                  where pgc.relname = '''' || tg_relname || '''' and
                  pgc.oid = pga.attrelid and pga.attnum > 0 and
                  attisdropped <> ''t'' Loop
      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....

Thanks,
Wilton Ruffato Wonrath

--
No virus found in this outgoing message.
Checked by AVG Anti-Virus.
Version: 7.0.300 / Virus Database: 265.7.6 - Release Date: 27/1/2005
---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?
              http://archives.postgresql.org