get_hourly_statistics_for_stream_and_type(p_stream_id integer, p_stream_statistic_type_id integer, p_start_date timestamp without time zone, p_end_date timestamp without time zone)

Description

Returns hourly aggregated statistics (avg, min, max, count) for a stream and type within a date range.

Parameters

Name	Type	Mode
p_stream_id	integer	IN
p_stream_statistic_type_id	integer	IN
p_start_date	timestamp without time zone	IN
p_end_date	timestamp without time zone	IN
hour_timestamp	timestamp without time zone	TABLE
avg_value	numeric	TABLE
min_value	integer	TABLE
max_value	integer	TABLE
count_entries	integer	TABLE

Definition