get_daily_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 daily 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
day_date date TABLE
avg_value numeric TABLE
min_value integer TABLE
max_value integer TABLE
count_entries integer TABLE

Definition