psql.sql

SELECT
IF user_id IS NULL THEN
  INSERT INTO scores(issue_id, user_id, group_id, value, created_at, updated_at)
  VALUES($1, NULL, $3, $4, $5, $6)
  ON CONFLICT(issue_id, group_id) DO UPDATE
    SET value = $4, updated_at = $6
ELSE
  INSERT INTO scores(issue_id, user_id, group_id, value, created_at, updated_at)
  VALUES($1, $2, NULL, $4, $5, $6)
  ON CONFLICT(issue_id, user_id) DO UPDATE
    SET value = $4, updated_at = $6
END IF