Changeset 31d5dd7ae5a1a551b1d6b995ac08588191019405

Show
Ignore:
Timestamp:
10/23/09 18:26:09 (4 years ago)
Author:
Depesz Lubaczewski <depesz@omniti.com>
git-committer:
Depesz Lubaczewski <depesz@omniti.com> 1256322369 +0000
git-parent:

[54b93a1e1604123f50988175daf9d9f718b8bbaf]

git-author:
Depesz Lubaczewski <depesz@omniti.com> 1256322369 +0000
Message:

oops, forgot to add previus v_sql

Files:

Legend:

Unmodified
Added
Removed
Modified
Copied
Moved

  • sql/sprocs/stratcon.unroll_metric_numeric.sql

    r54b93a1 r31d5dd7  
    3535        -- which means - for every given sid/name - we will search for only this sid/name. But when given NULLs, it will return data on all sid/names. 
    3636        v_sql := 'SELECT * FROM metric_numeric_rollup_' || in_roll || ' WHERE '; 
    37         v_sql := 'rollup_time = $1 AND sid = coalesce( $2, sid ) AND "name" = coalesce( $3, "name" )'; 
     37        v_sql := v_sql || 'rollup_time = $1 AND sid = coalesce( $2, sid ) AND "name" = coalesce( $3, "name" )'; 
    3838 
    3939        -- Following code (EXECUTE ... USING ... will work only from 8.4 on!