root/sql/sprocs/stratcon.init_metric_numeric_rollup_5m.sql

Revision 06c1b7054cfec11099d48bb3a27833d5e8ab1974, 407 bytes (checked in by Theo Schlossnagle <jesus@omniti.com>, 4 years ago)

merge skeksis back into trunk... we're sharded

  • 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.