The Interpolator function has one output table, which contains the time series with the values that the function calculated. Each row contains one time point in the series and one or more values. The following table describes the output table. Columns copied from input_table appear in the same order in the output table.
Column | Data Type | Description |
---|---|---|
time_column | INTEGER, BIGINT, SMALLINT, DOUBLE PRECISION, DECIMAL(n,n), DECIMAL, NUMERIC, NUMERIC(n,n), DATE, TIME, TIME(n), TIME WITH TIME ZONE, TIME WITH TIME ZONE(n), TIMESTAMP, TIMESTAMP(n), TIMESTAMP WITH TIME ZONE, or TIMESTAMP WITH TIME ZONE(n) | Contains the time points in the time series. This column corresponds to time_column in input_table. |
value_column | INTEGER, BIGINT, SMALLINT, DOUBLE PRECISION, DECIMAL(n,n), DECIMAL, NUMERIC, NUMERIC(n,n), CHARACTER, CHARACTER(n), CHARACTER VARYING, CHARACTER VARYING(n), or VARCHAR For data types CHARACTER, CHARACTER(n), CHARACTER VARYING, CHARACTER VARYING(n), and VARCHAR, the only supported interpolation type is 'constant'.
|
Contains values for the time points in time_column. This column corresponds to a value_column in input_table. The table can have more than one such column. |
accumulate_column | Any | Column copied from input_table, specified by the Accumulate argument. Typically, one accumulate_column is a row identifier, such as 'id'. |