Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Question of plpgsql: Create trigger on the employees table. This time, if the salary is null, set the salary equal to the smallest salary in
Question of plpgsql: Create trigger on the employees table. This time, if the salary is null, set the salary equal to the smallest salary in the employees table + 5000. In other words, if the table has the same three rows as above (question 1), then an insert of (20, Tracy, null) will insert Tracy and set their salary to 40000 (= min salary + 5000) (= 35000 + 5000).
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started