Re: [SQL] Function Doubt

2005-01-27 Thread Richard Huxton
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 sta

[SQL] Function Doubt

2005-01-27 Thread 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