SQL Notebook (logo)

ARRAY Function

Creates an array from the specified arguments. Arrays are encoded as BLOBs. 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([value1], [value2], ...)

Arguments

Return Value

A BLOB value containing the encoded array.

Examples