Skip to main content
Journey Uncommon Logo
JourneyUncommon
mediumSQLtriggersSingle-choice MCQ

A single trigger is declared for multiple events: BEFORE INSERT OR UPDATE. Inside the function you must branch on which event fired. Which check is correct?

CREATE TRIGGER trg BEFORE INSERT OR UPDATE ON t FOR EACH ROW EXECUTE FUNCTION fn(); -- inside fn():