0

I want to use trigger on specific table where task is to perform update on one column of each row when request for delete is made.

I cant use INSTEAD OF here as it only supports view.

Improve this question
1
  • 1
    Rules Commented Oct 23, 2016 at 20:29

1 Answer 1

Reset to default
3

Two ways I can think of straight away:

  1. Create a rule for such behaviour with CREATE RULE
  2. Create a BEFORE DELETE trigger performing UPDATE when fired and return NULL from it. See CREATE TRIGGER
Improve this answer
Sign up to request clarification or add additional context in comments.

Comments

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.