From c76b9060accd45b984aa831a4b98d3109befd49f Mon Sep 17 00:00:00 2001
From: glyn <glyn@8kb.co.uk>
Date: Fri, 5 Dec 2014 18:22:49 +0000
Subject: [PATCH] Stop doing useless work

---
 pg_settings_history.plpgsql | 16 ++++++++++------
 1 file changed, 10 insertions(+), 6 deletions(-)

diff --git a/pg_settings_history.plpgsql b/pg_settings_history.plpgsql
index 371b9f8..3c7102f 100755
--- a/pg_settings_history.plpgsql
+++ b/pg_settings_history.plpgsql
@@ -59,13 +59,17 @@ BEGIN
         
         GET DIAGNOSTICS v_changes = ROW_COUNT;
 
-        -- Update the snapshot ready for the next run.
-        TRUNCATE public.pg_settings_last;
-        INSERT INTO pg_settings_last (name, setting, unit, category, short_desc, extra_desc, context, vartype, source, min_val, 
+        IF (v_changes > 0) THEN
+            -- Update the snapshot ready for the next run.
+            TRUNCATE public.pg_settings_last;
+            INSERT INTO pg_settings_last (name, setting, unit, category, short_desc, extra_desc, context, vartype, source, min_val, 
                 max_val, enumvals, boot_val, reset_val, sourcefile, sourceline)
-        SELECT * FROM pg_settings;
-    
-        RETURN (v_changes > 0);
+            SELECT * FROM pg_settings;
+
+            RETURN true;
+   	ELSE 
+            RETURN false;
+	END IF; 
     END IF;    
 END;
 
-- 
2.39.2