
The CARDINALITY function returns a value representing the number of elements of an array.
The value returned by the CARDINALITY function is the highest subindex for which the array has an assigned element. This includes elements that have been assigned the null value.
The result of the function is BIGINT. The function returns 0 if the array is empty. The result can be null; if the argument is null, the result is the null value.
Assume that type INT_ARRAY is defined as:
CREATE TYPE INT_ARRAY AS INTEGER ARRAY[100]The SET statement in the following code fragment assigns variable LEN the value 4.
BEGIN DECLARE LEN INTEGER; DECLARE MYARRAY INT_ARRAY; SET MYARRAY = ARRAY[0,0,1,1]; SET LEN = CARDINALITY(MYARRAY); END
