From 1445d0fc9be0cb3ff3547fb946c53072a28b6da2 Mon Sep 17 00:00:00 2001 From: David Kaufmann Date: Sat, 6 Apr 2019 04:22:50 +0200 Subject: [PATCH] now the results are the same --- ex1/main_5.tex | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/ex1/main_5.tex b/ex1/main_5.tex index 315cec5..8c13d5f 100644 --- a/ex1/main_5.tex +++ b/ex1/main_5.tex @@ -7,7 +7,7 @@ local: 45s vs 31ms \item SELECT score FROM comments WHERE text ILIKE 'yes\%'; <- did not work (100ms instead of 33ms) - \item SELECT postid FROM votes WHERE postid NOT IN (SELECT postid FROM votes WHERE votetypeid != 2); + \item SELECT DISTINCT postid FROM votes WHERE postid NOT IN (SELECT postid FROM votes WHERE votetypeid != 2); local: 16m vs 35ms \end{enumerate} -- 2.43.0