Skip to content

Instantly share code, notes, and snippets.

Show Gist options
  • Save HaruKawamata/97ca803581fd27629efbda9544b24a6d to your computer and use it in GitHub Desktop.
Save HaruKawamata/97ca803581fd27629efbda9544b24a6d to your computer and use it in GitHub Desktop.
`insert into "user_words" ("proficiency", "result_ids", "user_id", "word_id") values (1, '{256}', 1, 1) ON CONFLICT (user_id, word_id) UPDATE user_words SET "user_id" = 1, "word_id" = 1, "proficiency" = 1, "result_ids" = '{256}' where user_words.word_id = 1 AND user_words.user_id = 1 - syntax error at or near "UPDATE"`
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment