ARRAY_SIZE

​

Syntax

​

Scalar

array_size(value)

​

Arguments

​

Returns

• Type: unsigned 64-bit integer; query tools may report INTEGER
• Possible values: A nonnegative count; zero for an empty collection.
• NULL behavior: Returns NULL for a NULL collection.

​

Properties

​

Usage notes

• NULL elements count toward array size.
• INTEGER and INT mean the same type; STRING means VARCHAR text. NULL can be used with a supported type. Cast NULL explicitly when its type would otherwise be unclear.

​

Examples

​

Typical behavior

SELECT array_size(ARRAY[1, NULL, 2]) AS elements;

​

Count strings including NULL

SELECT array_size(ARRAY('red', CAST(NULL AS VARCHAR), 'blue')) AS element_count;

​

Limitations

• The size is returned as an unsigned 64-bit integer, even when query tools report INTEGER. Some nonstandard array storage formats can raise an error.