Changeset 06519e0d896bfca30746212670c342a1b84a74a5

Show
Ignore:
Timestamp:
07/10/09 00:26:52 (5 years ago)
Author:
Theo Schlossnagle <jesus@omniti.com>
git-committer:
Theo Schlossnagle <jesus@omniti.com> 1247185612 +0000
git-parent:

[7c60f54e4eb92ac75f500f899486a84549164a07]

git-author:
Theo Schlossnagle <jesus@omniti.com> 1247185612 +0000
Message:

Patch from Dan. fixes #153

Files:

Legend:

Unmodified
Added
Removed
Modified
Copied
Moved
  • sql/reconnoiter_ddl_dump.sql

    rf6540ba r06519e0  
    24482448   rec.sid := null; 
    24492449   rec.name := null; 
     2450   rec.count_rows := 0; 
     2451   rec.avg_value := 0; 
    24502452   rise := 0; 
    24512453   run := 0; 
     
    24972499    last_value := r.value; 
    24982500  end if; 
    2499 end loop; 
     2501  end loop; 
     2502  if rec.count_rows > 0 then 
     2503    rec.avg_value := rec.avg_value / rec.count_rows; 
     2504    if run is not null and run > 0 then 
     2505      rec.counter_dev := rise/run; 
     2506    end if; 
     2507    return next rec; 
     2508  end if; 
    25002509return; 
    25012510end;