medium10 pts · first answer countsdatabasessqlconcurrency

Insert or update in one statement

A daily_stats row should be created the first time and incremented after that, safely under concurrency. Which PostgreSQL statement does this?

A.SELECT first, then INSERT if no row was foundB.UPDATE first, then INSERT if no row was changedC.DELETE the old row, then INSERT a fresh oneD.INSERT ... ON CONFLICT (day) DO UPDATE SET hits = ...

Discussion 0

Join free to post in the discussion.

Insert or update in one statement

Discussion 0

Related questions