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.

Syntax

ARRAY([value], ...)

Parameters

• value, ...: scalar
  The values to include in the array.

Return Value

A BLOB value containing the encoded array.

Example

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

See Also

• ARRAY_GET Function