sgraham785 · March 23, 2018 15:45
diff --git a/pgsql_upsert.sql b/pgsql_upsert.sql
 INSERT INTO users (id, level)
 VALUES (1, 0)
 ON CONFLICT (id) DO UPDATE
 SET level = users.level + 1;

 INSERT INTO users (id, email)
 VALUES (1, [email protected])
 ON CONFLICT (id) DO UPDATE
 SET email = EXCLUDED.email;
	INSERT INTO users (id, level)
	VALUES (1, 0)
	ON CONFLICT (id) DO UPDATE
	SET level = users.level + 1;

	INSERT INTO users (id, email)
	VALUES (1, [email protected])
	ON CONFLICT (id) DO UPDATE
	SET email = EXCLUDED.email;