GitHub

sql-array-functions.md

ARRAY[expr1, expr2, ...] Constructs a SQL ARRAY literal from the provided expression arguments. All arguments must be of the same type. ARRAY_APPEND(arr, expr) Appends the expression to the array. The ...
GitHub

string_to_array.sql

WHILE COALESCE(array_length(a, 1), 0) < length(s) LOOP a[COALESCE(array_length(a, 1), 0) + 1] = substr(s, COALESCE(array_length(a, 1), 0) + 1, 1); ...