From 1789636ef7e0321025edd362557c36a8b49f9a03 Mon Sep 17 00:00:00 2001
From: schneefux <schneefux+commit@schneefux.xyz>
Date: Thu, 9 Mar 2017 18:49:18 +0100
Subject: attempt to fix duplicate matches

---
 insert.sql | 2 +-
 1 file changed, 1 insertion(+), 1 deletion(-)

(limited to 'insert.sql')

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
-- 
cgit v1.3.1

