ARRAY Function

Creates an array from the specified arguments. Arrays are represented using the SQLite "BLOB" data type. They can be stored in tables and variables and passed as arguments to functions, just like any other value. Large arrays should be avoided for performance reasons. For large amounts of data, consider using a dedicated table.


ARRAY([value], ...)


Return Value

A BLOB value containing the encoded array.


DECLARE @data = ARRAY(111, 222, 333);
PRINT ARRAY_GET(@data, 0); -- "111"
PRINT ARRAY_GET(@data, 2); -- "333"

See Also