Changeset 9c824156bbb942b0da737b077c77025f0b56c67d

Show
Ignore:
Timestamp:
05/09/08 20:53:07 (5 years ago)
Author:
Denish Patel <denish@omniti.com>
git-committer:
Denish Patel <denish@omniti.com> 1210366387 +0000
git-parent:

[3b5d1e9688429ed8e55ebcc0a750dda9a2fe54b4]

git-author:
Denish Patel <denish@omniti.com> 1210366387 +0000
Message:

fix 20 minutes rollup function.

Files:

Legend:

Unmodified
Added
Removed
Modified
Copied
Moved

  • sql/schema.sql

    r3b5d1e9 r9c82415  
    404404                       MIN(min_value) as min_value ,MAX(max_value) as max_value 
    405405                       FROM stratcon.rollup_matrix_numeric_5m 
    406                       WHERE ROLLUP_TIME<= v_min_whence AND WHENCE > v_min_whence -'20 minutes'::interval 
     406                      WHERE rollup_time<= v_min_whence AND rollup_time > v_min_whence -'20 minutes'::interval 
    407407                GROUP BY rollup_time,sid,name 
    408408