Re: Function Doubt - Mailing list pgsql-sql

From Richard Huxton
Subject Re: Function Doubt
Date
Msg-id 41F92145.40603@archonet.com
Whole thread Raw
In response to Function Doubt  (Wilton <wilton.wonrath@microwork.inf.br>)
List pgsql-sql
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


pgsql-sql by date:

Previous
From: Richard Huxton
Date:
Subject: Re: hardware mod based on feedback from the list
Next
From: "Keith Worthington"
Date:
Subject: Re: hardware mod based on feedback from the list