This is a discussion on Re: Function Doubt within the pgsql Sql forums, part of the PostgreSQL category; --> Wilton wrote: > StrCampo = ''new.'' || qCampos.attname; > StrInsert = StrInsert || virgula || StrCampo || '' - ...
| |||||||
| Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
| ||||
| 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 |