squash! Reduce database size and variance of query response times.

- Use := rather than = for assignments, for consistency.

squash! Reduce database size and variance of query response times.
2cb74cd9 · Karsten Loesing · 8159855b · 2cb74cd9
Commit 2cb74cd9 authored 6 years ago by Karsten Loesing
--- a/src/main/sql/exonerator2.sql
+++ b/src/main/sql/exonerator2.sql
@@ -410,8 +410,8 @@ BEGIN
       OR last_date IS NULL OR DATE(rec.validafter) != last_date THEN
      PERFORM insert_date_address24(DATE(rec.validafter), oraddress24,
         last_fingerprint_id);
-      last_address24 = oraddress24;
-      last_date = DATE(rec.validafter);
+      last_address24 := oraddress24;
+      last_date := DATE(rec.validafter);
    END IF;
    last_nickname := matches[1];
    last_fingerprint_base64 := matches[2];
@@ -448,8 +448,8 @@ BEGIN
       OR last_date IS NULL OR DATE(rec.scanned) != last_date THEN
      PERFORM insert_date_address24(DATE(rec.scanned), rec.exitaddress24,
          last_fingerprint_id);
-      last_address24 = rec.exitaddress24;
-      last_date = DATE(rec.scanned);
+      last_address24 := rec.exitaddress24;
+      last_date := DATE(rec.scanned);
    END IF;
    last_fingerprint_base64 := fingerprint_base64;
    copied_rows := copied_rows + 1;