UpdSet function

Syntax

UpdSet(ts     TimeSeries, 
        set_ts multiset,
        flags  integer default 0) 
returns TimeSeries;

ts

The time series to update.

set_ts

A set of rows that replace existing elements in the given time series, ts.

flags

Valid values for the flags argument are described in The flags argument values. The default is 0.

Description

The rows in set_ts must be of the correct type for the time series, beginning with a time stamp; otherwise, an error is raised. If the time stamp of any element does not correspond to an element already in the time series, an error is raised, and the entire update is void.

Hidden elements cannot be updated.

Returns

The updated time series.

Example

update activity_stocks
set activity_data = (select UpdSet(activity_data, set_data)
            from activity_load_tab where stock_id = 600)
where stock_id = 600;