commit 92cbc074b9bee07d4b3243070788187080dccd05 Author: Karsten Loesing karsten.loesing@gmx.net 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;