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.

1 files 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;