root/sql/sprocs/stratcon.init_metric_numeric_rollup_5m.sql

Revision 0136c0f3f48fe6e4addf4d56caccce5608118f37, 407 bytes (checked in by Robert Treat <robert@omniti.com>, 5 years ago)

we should probably name this appropriatly, round duex

  • Property mode set to 100644
Line 
1 CREATE OR REPLACE FUNCTION stratcon.init_metric_numeric_rollup_5m()
2 RETURNS SETOF noit.metric_numeric_rollup_5m
3 AS $$
4   SELECT null::int, null::text, null::timestamptz, array_agg(count_rows), array_agg(avg_value), array_agg(counter_dev) from (select NULL::int as count_rows, NULL::numeric as avg_value, NULL::numeric as counter_dev from generate_series(1,288)) x;
5 $$
6 LANGUAGE 'sql'
7 SECURITY DEFINER
8 ;
9
10
Note: See TracBrowser for help on using the browser.