Re: Trigger: Column Update - Mailing list pgsql-admin

From Guillaume Lelarge
Subject Re: Trigger: Column Update
Date
Msg-id 4CDD7E40.2020401@lelarge.info
Whole thread Raw
In response to Trigger: Column Update  (Ricardo Bayley <ricardo.bayley@gmail.com>)
Responses Re: Trigger: Column Update
List pgsql-admin
Le 12/11/2010 18:37, Ricardo Bayley a écrit :
> 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 ?

Nope. You should check yourself.

> Or should we check this ourselves doing something like OLD.columnA !=
> NEW.columnA ?

Use IS DISTINCT OF instead of = to deal with NULL values.


--
Guillaume
 http://www.postgresql.fr
 http://dalibo.com

pgsql-admin by date:

Previous
From: Viktor Bojović
Date:
Subject: Re: GUI ERD/ERM tools?
Next
From: "Kevin Grittner"
Date:
Subject: Re: locales and encodings Oh MY!