Re: Function Doubt

From: Richard Huxton <dev(at)archonet(dot)com>
To: Wilton <wilton(dot)wonrath(at)microwork(dot)inf(dot)br>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: Function Doubt
Date: 2005-01-27 17:13:41
Message-ID: 41F92145.40603@archonet.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Wilton 2005-01-27 17:32:10 Function Doubt
Previous Message Richard Huxton 2005-01-27 17:11:55 Re: hardware mod based on feedback from the list