Changeset 32ddc52a40c4d76a2cfc234cae27df4212c7c745 for sql
- Timestamp:
- 10/21/09 15:50:40 (9 years ago)
- git-parent:
- Files:
-
- sql/sprocs/stratcon.rollup_metric_numeric_5m.sql (modified) (3 diffs)
Legend:
- Unmodified
- Added
- Removed
- Modified
- Copied
- Moved
sql/sprocs/stratcon.rollup_metric_numeric_5m.sql
re746129 r32ddc52 51 51 IF v_min_whence <= v_max_rollup_5 THEN 52 52 -- do we still need this? i think "we" dont, but maybe some people do? 53 DELETE FROM rollup_matrix_numeric_5m53 DELETE FROM metric_numeric_rollup_5m 54 54 WHERE rollup_time = v_min_whence; 55 55 END IF; … … 59 59 v_offset := ( 12*(extract('hour' from v_min_whence))+floor(extract('minute' from v_min_whence)/5) ); 60 60 61 SELECT * FROM rollup_matrix_numeric_5m WHERE rollup_time = v_info.rollup_time AND sid=v_info.sid AND name=v_info.name INTO v_rec;61 SELECT * FROM metric_numeric_rollup_5m WHERE rollup_time = v_info.rollup_time AND sid=v_info.sid AND name=v_info.name INTO v_rec; 62 62 IF NOT FOUND THEN 63 SELECT * FROM init_rollup_matrix_numeric_5m() INTO v_rec;63 SELECT * FROM stratcon.init_metric_numeric_rollup_5m() INTO v_rec; 64 64 v_init := true; 65 65 END IF; … … 73 73 74 74 IF v_init THEN 75 INSERT INTO rollup_matrix_numeric_5m (sid,name,rollup_time,count_rows,avg_value,counter_dev)75 INSERT INTO metric_numeric_rollup_5m (sid,name,rollup_time,count_rows,avg_value,counter_dev) 76 76 VALUES (v_rec.sid,v_rec.name,v_rec.rollup_time,v_rec.count_rows,v_rec.avg_value,v_rec.counter_dev); 77 77 ELSE 78 UPDATE rollup_matrix_numeric_5m SET (count_rows,avg_value,counter_dev)78 UPDATE metric_numeric_rollup_5m SET (count_rows,avg_value,counter_dev) 79 79 = (v_rec.count_rows,v_rec.avg_value,v_rec.counter_dev) 80 80 WHERE rollup_time = v_info.rollup_time AND sid = v_info.sid AND name = v_info.name;