Reference Guide > TDV Support for SQL Functions > Array SQL Script Functions > EXTEND
 
EXTEND
This function appends the specified number of elements to a vector. The appended number of elements are assigned a NULL value, and the syntax is as follows:
SET vectorX = EXTEND (vectorX, 2);
If the number of elements specified to be appended evaluates to NULL, this function returns NULL.
If the vector is NULL, an error occurs, indicating that the vector is NULL.
If the specified number is a negative number, an error occurs.
Refer to the TDV Reference Guide Chapter TDV SQL Script for more information about Vectors and Functions.