On 05/11/2016 07:12 AM, Ezequiel Luis Pellettieri wrote:
Hi guys, I'm going to build a trigger on update for a few tables, but I have to ignore updates for certain users. Is there a way to accomplish this task?
test for the user and return NULL if there is a match:
"Row-level triggers fired BEFORE can return null to signal the trigger manager to skip the rest of the operation for this row (i.e., subsequent triggers are not fired, and the INSERT/UPDATE/DELETE does not occur for this row)."