Theo Dickinson <Theo(dot)Dickinson(at)unv(dot)org> writes:
> Within an update row level trigger how can I detect which field[s] has been
> effected by an update ?
You can compare OLD value with the NEW's one:
IF ( NEW.modified_by <> OLD.modified_by ) THEN
mod_by := 1; -- Use := for assigment
Note that in plpgsql the assigment operator is := and *not* = which
is a boolean operator for equality.
In response to
pgsql-novice by date
|Next:||From: Manuel Sugawara||Date: 2004-05-21 15:11:22|
|Subject: Re: postgre -> mysql|
|Previous:||From: Manuel Sugawara||Date: 2004-05-21 15:05:08|
|Subject: Re: Problem with public schema|