TSGetValueList function

The TSGetValueList function converts a string into a list of values that you can use as input to an advanced analytics function.

Syntax

TSGetValueList (value_string      LVARCHAR)       
RETURNS LIST (ROW (value DOUBLE PRECISION) NOT NULL) 

TSGetValueList (value_string       LVARCHAR,   
                num_elements       INTEGER)       
RETURNS LIST (ROW (value DOUBLE PRECISION) NOT NULL)

value_string: A character string that represents a list of data values.
num_elements: A positive integer that represents the number of input values to use from the start of the input string.

Usage

Run the TSGetValueList function to return a search pattern that you can use as input to an advanced analytics function. You can run the TSGetValueList function within an advanced analytics function as the pattern argument.

Returns

A list of row types that have a DOUBLE PRECISION field.

Example

The following statement returns a search pattern as a list of row types:

SELECT TSGetValueList('1.0 2.0')::LIST(ROW(value DOUBLE PRECISION) NOTNULL)
     FROM TABLE (SET{1}); 

(constant) LIST{ROW(1.000000000000),ROW(2.000000000000)}