PostgreSQL - Triggers in PostgreSQL
If a statement-level AFTER UPDATE trigger logs the number of rows updated, what will it report after updating 3 rows?
If a statement-level AFTER UPDATE trigger logs the number of rows updated, what will it report after updating 3 rows?
medium📝 query result Q5 of 15
Step-by-Step Solution
Solution:
Step 1: Understand statement-level AFTER UPDATE trigger behavior
This trigger fires once after the entire update statement completes.Step 2: Determine the number of rows affected
The update affected 3 rows, so the trigger logs 3.Final Answer:
3 -> Option BQuick Check:
Statement-level AFTER UPDATE trigger logs total rows = 3 [OK]
Quick Trick: Statement-level triggers fire once per statement, not per row [OK]
Common Mistakes:
- Thinking trigger fires once per row
- Assuming zero rows updated
- 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