Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-admin by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group