SQLize Online / PHPize Online  /  SQLtest Online

A A A
Share      Blog   Popular
Copy Format Clear
CREATE OR REPLACE FUNCTION trigger_fun() RETURNS TRIGGER AS $$ --BODY DECLARE -- VAR BEGIN --LOGIC -- IF NEW.price_msrp < OLD.price_msrp THEN IF NEW.price_msrp == OLD.price_msrp THEN INSERT INTO Product_UPDATES(item_id, old_min_price, new_min_price, date) VALUES (OLD.item_id ,OLD.price_msrp, NEW.price_msrp, now()); END IF; RETURN NEW; END; $$ LANGUAGE PLPGSQL; -- TRIGGER DROP TRIGGER IF EXISTS tr_trigger_before_insert_product ON Product; CREATE TRIGGER tr_trigger_before_insert_product BEFORE UPDATE ON Product FOR EACH ROW EXECUTE PROCEDURE trigger_fun();
Stuck with a problem? Got Error? Ask ChatGPT!
Copy Clear