TRUNCATE
This function removes a specified number of elements (the “chop count”) from the end of a vector. The syntax is as follows:
SET vector1 = TRUNCATE (vector1, chop_count)
• If the chop count evaluates to NULL, this function returns NULL.
• If the chop count is negative, or exceeds the initial size of the vector, an error occurs.
• If the vector is NULL, an error occurs.
• TRUNCATE is also a TDV-supported SQL function. Refer to
TRUNC, for a description.