Re: Field collection in trigger

Hi Doug,

Thanks for anwsers, do you have some sample code or URL where I can get
more info on this. I don't know C or Perl but really need to get this done.

Thanks,

Doug McNaught wrote:

>Josué Maldonado <josue(at)lamundial(dot)hn> writes:
>
>
>
>>Hello list,
>>
>>First of all, excuse me if this is not the right place to ask my question.
>>
>>Is there a way in postgresql to loop to all the fields of a given
>>table and compare the OLD and NEW value for each field. I need to make
>>an audit table that must contain only the fields changed after and
>>insert/update.
>>
>>
>
>You should be able to do this in a Perl or C trigger. It can't be
>done in PL/pgSQL without writing a custom trigger for each table that
>hard-codes all the field names.
>
>-Doug
>
>---------------------------(end of broadcast)---------------------------
>TIP 3: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to majordomo(at)postgresql(dot)org so that your
> message can get through to the mailing list cleanly
>
>
>