STS_SubtrackAlterLagToCurrent function

The STS_SubtrackAlterLagToCurrent function changes the indexing lag time.

Syntax

STS_SubtrackAlterLagToCurrent(
      subtrack_name                 VARCHAR(128),
      ts_data_lag_to_current        INTERVAL DAY TO SECOND DEFAULT NULL)
returns INTEGER
subtrack_name
The name of the subtrack table.
ts_data_lag_to_current
The indexing lag time. The time interval before the current time to avoid indexing. Default is the time stamp of the latest element in the time series.

Usage

Run the STS_SubtrackAlterLagToCurrent function to change the value of the ts_data_lag_to_current parameter, as set by the STS_SubtrackCreate function. The change in indexing lag time takes effect when new data is loaded and indexed.

Returns

0 = The indexing lag time is changed.

An exception = An error.

Example

The following statement changes the indexing lag time to one hour:

EXECUTE FUNCTION STS_SubtrackAlterLagToCurrent(
        't_vehicle_subtrack', 
        '0 01:00:00'::INTERVAL DAY TO SECOND);