Re: Is this possible in a trigger?

On May 6, 11:05=A0pm, ferna...@[EMAIL PROTECTED]
 (Fernando) wrote:
> I want to keep a history of changes on a field in a table. =A0This will
be=

> the case in multiple tables.
>
> Can I create a trigger that loops the OLD and NEW values and compares
> the values and if they are different creates a change string as follows:
>
> e.g;
>
> FOR EACH field IN NEW
> =A0 =A0 IF field.value <> OLD.field.name THEN
> =A0 =A0 =A0 =A0changes :=3D changes
> =A0 =A0 =A0 =A0 =A0 =A0 || field.name
> =A0 =A0 =A0 =A0 =A0 =A0 || ' was: '
> =A0 =A0 =A0 =A0 =A0 =A0 || OLD.field.value
> =A0 =A0 =A0 =A0 =A0 =A0 || ' now is: '
> =A0 =A0 =A0 =A0 =A0 =A0 || field.value
> =A0 =A0 =A0 =A0 =A0 =A0 || '\n\r';
> =A0 =A0 END IF
> END FOR;
>
> Your help is really appreciated.
>
> Thank you.

in plpgsql you could

select new into textVar;

and then do acrobatics with the text value of that record... or
converting the text value into a known table record type with EXECUTE
'select ' || quote_literal(textVar) || '::tableRecord' INTO
tableRecordVar statement. But the field names are to be extracted from
the catalog anyway.

Or use plperl or plpython :(