[tor-commits] [exonerator/master] Take out ORDER BY statements.

[karsten@xxxxxxxxxxxxxx]

commit 92cbc074b9bee07d4b3243070788187080dccd05
Author: Karsten Loesing <karsten.loesing@xxxxxxx>
Date:   Tue Sep 5 15:21:25 2017 +0200

    Take out ORDER BY statements.
    
    We don't expect results to be in order, and taking out ORDER BY
    statements means we don't need to worry about replacing numbers with
    names for better readability.
---
 src/main/resources/db/exonerator.sql | 6 ++----
 1 file changed, 2 insertions(+), 4 deletions(-)

diff --git a/src/main/resources/db/exonerator.sql b/src/main/resources/db/exonerator.sql
index 85d5d01..233b43c 100755
--- a/src/main/resources/db/exonerator.sql
+++ b/src/main/resources/db/exonerator.sql
@@ -256,8 +256,7 @@ CREATE OR REPLACE FUNCTION search_by_address24_date (
           || '''::DATE + 1
       AND statusentry.validafter >= exitlistentry.scanned
       AND statusentry.validafter - exitlistentry.scanned <=
-          ''1 day''::INTERVAL
-  ORDER BY 2, 3, 4';
+          ''1 day''::INTERVAL';
   END;
 $$ LANGUAGE plpgsql;
 
@@ -291,8 +290,7 @@ CREATE OR REPLACE FUNCTION search_by_address48_date (
       FROM statusentry
       WHERE oraddress48 = ''' || select_address48 || '''
       AND DATE(validafter) >= ''' || select_date || '''::DATE - 1
-      AND DATE(validafter) <= ''' || select_date || '''::DATE + 1
-  ORDER BY 2, 3';
+      AND DATE(validafter) <= ''' || select_date || '''::DATE + 1';
   END;
 $$ LANGUAGE plpgsql;
 



_______________________________________________
tor-commits mailing list
tor-commits@xxxxxxxxxxxxxxxxxxxx
https://lists.torproject.org/cgi-bin/mailman/listinfo/tor-commits