Re: Update Row Level Trigger: default value for update trigger

#1

Theo Dickinson <Theo.Dickinson (AT) unv (DOT) org> writes:

Quote:

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.

Regards,
Manuel.

---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to majordomo (AT) postgresql (DOT) org

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Re: Update Row Level Trigger: default value for update trigger

comp.databases.postgresql.novice comp.databases.postgresql.novice

Re: Update Row Level Trigger: default value for update trigger - 05-21-2004 , 10:10 AM