From 4f6f18fc3ad0f0a62f0db20e3e6e8d5a2bb190bf Mon Sep 17 00:00:00 2001
From: Random Hacker <random_hacker@xapek.org>
Date: Mon, 5 Dec 2011 22:47:24 +0100
Subject: use current_timestamp; add notify

---
 sql/populate_cache.sql | 12 ++++++------
 1 file changed, 6 insertions(+), 6 deletions(-)

(limited to 'sql/populate_cache.sql')

diff --git a/sql/populate_cache.sql b/sql/populate_cache.sql
index f302607..2733cbb 100644
--- a/sql/populate_cache.sql
+++ b/sql/populate_cache.sql
@@ -1,9 +1,9 @@
 drop table value_cache cascade;
 
 CREATE TABLE value_cache (
-value_real integer,
-timestamp timestamp,
-sensor_id integer
+	value_real integer,
+	timestamp timestamp,
+	sensor_id integer
 );
 
 create or replace view vi_value_cache as 
@@ -13,14 +13,14 @@ UNION
   SELECT date_trunc('hour', timestamp), sensor_id, COALESCE(avg(value_int),avg(value_float)), 'LIVE'
     FROM value
    WHERE date_trunc('hour', timestamp) > coalesce((select max(timestamp) from value_cache), 
-                                                  now() - interval '2 days')
+                                                  CURRENT_TIMESTAMP - interval '2 days')
 GROUP BY date_trunc('hour', timestamp), sensor_id;
 ;
 
 
 CREATE OR REPLACE FUNCTION value_cache_aktualisieren() RETURNS timestamp AS $value_cache_aktualisieren$
 DECLARE
-   last_update timestamp = now();
+   last_update timestamp = CURRENT_TIMESTAMP;
 BEGIN
     select max(date_trunc('hour'::text, "timestamp"))
       into last_update
@@ -28,7 +28,7 @@ BEGIN
 
     RAISE NOTICE 'last update=%', last_update;
     if last_update is NULL then
-      last_update = now() - interval '20 days';
+      last_update = CURRENT_TIMESTAMP - interval '20 days';
       RAISE NOTICE 'last update set to %', last_update;
     end if;
 
-- 
cgit v1.2.1

