Function Doubt

From: Wilton <wilton(dot)wonrath(at)microwork(dot)inf(dot)br>
To: pgsql-sql(at)postgresql(dot)org
Subject: Function Doubt
Date: 2005-01-27 17:32:10
Message-ID: 41F9259A.2080402@microwork.inf.br
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Keith Worthington 2005-01-27 17:35:56 Re: hardware mod based on feedback from the list
Previous Message Richard Huxton 2005-01-27 17:13:41 Re: Function Doubt