IBM PureData System for Analytics, Version 7.1

The array_type() function

The array_type() function returns the type of the array.

Description

The array_type() function has the following syntax:

int = array_type(array input);

The input value specifies the array for which to get the type.

For example:

select array_type(array(4));
 array_type 
------------
          4
(1 row)

This second example displays the type of array stored in the array_t table:

select array_type(col2)from array_t;
 array_type 
------------
          2
(1 row)