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. -- Simon Riggs www.2ndQuadrant.com -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general