Functions/Lists & arrays/array_resize
Lists & arrays Scalar

array_resize()

Resizes the list to contain size elements. Initializes new elements with value or NULL if value is not set.

Alias of list_resize()

Arguments & returns

2 overloads

array_resize(list, size[)

Scalar
Overload link listsize[ Returns
#01 ANY[]ANY ANY[]

array_resize(list, size[, value])

Scalar
Overload link listsize[value] Returns
#02 ANY[]ANYANY ANY[]

Example

array_resize example
SQL
Haybarn WASM 1.5.5-rc3 · In your browser

Engine example · Run to view results.

Catalog examples

SELECT
  list_resize([1, 2, 3], 5, 0);