summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
-rw-r--r--insert.sql2
1 files changed, 1 insertions, 1 deletions
diff --git a/insert.sql b/insert.sql
index 3064e9b..bc6485d 100644
--- a/insert.sql
+++ b/insert.sql
@@ -67,7 +67,7 @@ linked_matches AS (
),
-- insert!
insert_matches AS (
- INSERT INTO match(id, data) SELECT * FROM linked_matches WHERE linked_matches.data->'data'->'attributes'->>'gameMode'='casual' OR linked_matches.data->'data'->'attributes'->>'gameMode'='ranked'
+ INSERT INTO match(id, data) SELECT * FROM linked_matches
ON CONFLICT(id) DO NOTHING
RETURNING id
)