PostgreSQL - Triggers in PostgreSQL
Which record variable would you use in a BEFORE INSERT trigger to access the row data being inserted?
Which record variable would you use in a BEFORE INSERT trigger to access the row data being inserted?
easy📝 Conceptual Q2 of 15
Step-by-Step Solution
Solution:
Step 1: Identify trigger type
In BEFORE INSERT triggers, the row does not exist yet, so OLD is not available.Step 2: Use NEW record
NEW holds the data that will be inserted, so it is the correct record to access.Final Answer:
NEW -> Option AQuick Check:
NEW = row data to be inserted [OK]
Quick Trick: Use NEW for data being inserted in BEFORE INSERT triggers [OK]
Common Mistakes:
- Using OLD in INSERT triggers
- Assuming OLD_ROW is valid
- Using PRE_INSERT which does not exist
Master "Triggers in PostgreSQL" in PostgreSQL
Want More Practice?
15+ quiz questions · All difficulty levels · Free
Free Signup - Practice All QuestionsMore PostgreSQL Quizzes