Trigger: Column Update

From: Ricardo Bayley <ricardo(dot)bayley(at)gmail(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: Trigger: Column Update
Date: 2010-11-12 17:37:37
Message-ID: AANLkTikj3q=rg-Cmtp8DktVkS7gAvO-tJQ+=4G0R7ECj@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hi,

I am wondering if there is a way to identify which columns have been
modified. Is there some sort of TG_TABLE_NAME, which states the
modified columns ?
Or should we check this ourselves doing something like OLD.columnA !=
NEW.columnA ?

Regards

Ricardo

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Viktor Bojović 2010-11-12 17:46:30 Re: GUI ERD/ERM tools?
Previous Message mark 2010-11-12 16:27:20 Re: locales and encodings Oh MY!