Skip to main content
Journey Uncommon Logo
JourneyUncommon
mediumSQLupserts ON CONFLICT MERGESingle-choice MCQ

You run the upsert below. There is a UNIQUE constraint on email. A row with email 'a@x.com' already exists with name 'Old'. What is the resulting name for that row?

INSERT INTO users (email, name) VALUES ('a@x.com', 'New') ON CONFLICT (email) DO UPDATE SET name = EXCLUDED.name;