Field collection in trigger

From: Josué Maldonado <josue(at)lamundial(dot)hn>
To: pgsql-general(at)postgresql(dot)org
Subject: Field collection in trigger
Date: 2003-09-01 18:42:24
Message-ID: bj03tg$2270$1@news.hub.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hello list,

First of all, excuse me if this is not the right site 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.

Thanks in advance

Josué Maldonado.

Browse pgsql-general by date

  From Date Subject
Next Message Carmen Gloria Sepulveda Dedes 2003-09-01 19:10:22 Re: Multiple Connections
Previous Message Bruce Momjian 2003-09-01 17:12:06 Re: mysql's last_insert_id