TSRowToList function

The TSRowToList function returns a list (collection of rows) containing the individual columns from a time series column plus the non-time-series columns of a table. Null elements are not added to the list.

Syntax

TSRowToList(ts_row     row)
returns list (row not null)
ts_row
A row value that contains a time series as one of its columns.

Description

The TSRowToList function can only be used on rows with one TimeSeries column.

You must cast the return variable to match the names and types of the columns being returned exactly.

Returns

A list (collection of rows).

Example

The query returns a list of rows, each containing the following columns: stock_id, stock_name, t, high, low, final, vol.
select TSRowToList(d)::list(row(stock_id integer, 
                                 stock_name lvarchar,
                                 t datetime year to fraction(5),
                                 high real, 
                                 low real,
                                 final real,
                                 vol real) not null) 
   from daily_stocks d;