On Fri, Aug 28, 2009 at 08:07:40PM +0100, Simon Riggs wrote:
-
- On Fri, 2009-08-28 at 08:50 -0700, David Kerr wrote:
-
- > so, is there a way in a trigger to know if edited_by is expressly
- > being set in the update statement? it seems like if I can know that,
- > then i should be able to figure it out.
-
- No, but you could use a before trigger to reset the value to NULL prior
- to each update, then your after trigger would work.
hmm, that's probably not worth it. fireing two triggers just to get an
edited_by column filled in.
Thanks
Dave