summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorschneefux <schneefux+commit@schneefux.xyz>2017-03-09 18:49:18 +0100
committerschneefux <schneefux+commit@schneefux.xyz>2017-03-09 18:49:18 +0100
commit1789636ef7e0321025edd362557c36a8b49f9a03 (patch)
tree475cd3849421b07f7e9bd270b9ea61fd55ea763c
parentf140744e626ca9b1af8097f43cc67201dcce59d1 (diff)
downloadapigrabber-1789636ef7e0321025edd362557c36a8b49f9a03.tar.gz
apigrabber-1789636ef7e0321025edd362557c36a8b49f9a03.zip
attempt to fix duplicate matches
-rw-r--r--insert.sql2
1 files changed, 1 insertions, 1 deletions
diff --git a/insert.sql b/insert.sql
index 6ce34a6..3064e9b 100644
--- a/insert.sql
+++ b/insert.sql
@@ -71,4 +71,4 @@ insert_matches AS (
ON CONFLICT(id) DO NOTHING
RETURNING id
)
-SELECT id FROM insert_matches
+SELECT DISTINCT id FROM insert_matches