PostgreSQL - Triggers in PostgreSQL
Given a row-level BEFORE INSERT trigger that increments a column value by 1, what will be the new value if the inserted row has column value 5?
Given a row-level BEFORE INSERT trigger that increments a column value by 1, what will be the new value if the inserted row has column value 5?
medium📝 query result Q4 of 15
Step-by-Step Solution
Solution:
Step 1: Understand BEFORE INSERT row-level trigger effect
The trigger modifies the row before insertion, incrementing the column by 1.Step 2: Calculate new value
Original value 5 plus 1 equals 6, so the inserted row will have 6.Final Answer:
6 -> Option DQuick Check:
Row-level BEFORE INSERT trigger increments value = 6 [OK]
Quick Trick: BEFORE INSERT row-level triggers can modify row values [OK]
Common Mistakes:
- Assuming original value remains unchanged
- Confusing BEFORE and AFTER timing
- Expecting error without cause
Master "Triggers in PostgreSQL" in PostgreSQL
Want More Practice?
15+ quiz questions · All difficulty levels · Free
Free Signup - Practice All QuestionsMore PostgreSQL Quizzes