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
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 |