Re: Update triggers - can you detect columns not being updated?

Seem to me that you should be able to within the trigger test for new.user_id etc.

IE: IF new.user_id IS NULL

     THEN
           user_id := 'Outside'; 
     END IF;

Good luck.

Alex Jentilucci - Consultant
Information System Dynamics, Inc
Minneapolis, MN 55323
Tele: 612-476-7395 FAX: 612-473-5954 E-Mail: infosys_at_aol.com

E-Mail Work: jentilucci_at_notes.seagate.com

          Home: AlexJent_at_aol.com Received on Wed Jan 08 1997 - 00:00:00 CST