From 1789636ef7e0321025edd362557c36a8b49f9a03 Mon Sep 17 00:00:00 2001 From: schneefux 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