diff options
-rw-r--r-- | unscoop.c | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/unscoop.c b/unscoop.c index 7c04ca1..04e0ca7 100644 --- a/unscoop.c +++ b/unscoop.c @@ -286,7 +286,7 @@ static void dedupEvents(sqlite3 *db) { WITH potentials (event, diff) AS ( SELECT event, event - first_value(event) OVER matching FROM events JOIN names USING (name) - WINDOW matching ( + WINDOW matching AS ( PARTITION BY time, type, context, nick, target, message ORDER BY event ) |