On Sunday 21 September 2003 02:38, you wrote:
> Thilak babu wrote:
> > I have a scnerio as to fire a trigger when i update a particular column
> > in a table. Please do help me out in getting thro this.
>
> The trigger function can use logic to exclude cases where a particular
> column does not change. For example:
>
> CREATE FUNCTION "column_update" () RETURNS TRIGGER AS '
> BEGIN
> IF ( NEW.column <> OLD.column ) THEN
> do-your-stuff-here;
> END IF;
> RETURN NEW;
> END; ' LANGUAGE 'plpgsql';
this trigger will not execute "your-stuff-here"
if NEW.column or OLD.column will be null.
you need to add this case to the logic statement in the "IF"
(NEW.column <> OLD.column) OR (NEW.column IS NULL <> OLD.column. IS NULL)