This website is for reference purposes only. Users are responsible for any misuse. The owner is not liable for any consequences.
Back to Database Management Systems (Laboratory)
8.1.2HardCODE

Trigger after DELETE

Question

Solution

SQL

CREATE OR REPLACE FUNCTION restore_product_quantity() 
RETURNS TRIGGER AS $$
BEGIN
	UPDATE products
	SET quantity = quantity + OLD.quantitysold
	WHERE productid = OLD.productid;

	RETURN NULL;
END;

$$LANGUAGE plpgsql;

CREATE TRIGGER after_sales_delete
AFTER DELETE ON sales
FOR EACH ROW
EXECUTE FUNCTION restore_product_quantity()

1/1 test cases passed

2/2 hidden test cases passed