Question

Which one of two SQL triggers (MYSQL,PostgreSQL) appears easy to you and why would you recommend it to your boss who depends on your technical input to makes the final software license acquisition decision? Which trigger type would you recommend to your boss?

(MYSQL)

CREATE TRIGGER trig__mileage

BEFORE INSERT ON mileage

FOR EACH ROW

SET NEW.mpg = NEW.miles / NEW.gallons;

(PostgreSQL)

CREATE TRIGGER trig__mileage

BEFORE INSERT ON mileage

FOR EACH ROW

EXECUTE PROCEDURE trig_proc_calculate_mpg();

Answer 1

As both PostgreSql and MySql support triggers, I would recommend PostgreSql Triggers because Mysql Trigger limits to some commands.

But PostgreSql Support triggers that can fire on most types of command, except for ones affecting the database globally e.g., roles and tablespaces.

Hence, as the PostgreSql trigger given here in this context

CREATE TRIGGER trig__mileage

BEFORE INSERT ON mileage

FOR EACH ROW

EXECUTE PROCEDURE trig_proc_calculate_mpg();

which does not contain any roles and table spaces, PostgreSql Trigger is recommended.