Functions/Lists & arrays/array_select
Lists & arrays Scalar

array_select()

Returns a list based on the elements selected by the index_list.

Alias of list_select()

Arguments & returns

array_select(value_list, index_list)

Scalar
Overload link value_listindex_list Returns
#01 ANY[]BIGINT[] ANY[]

Example

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

Engine example · Run to view results.

Catalog examples

SELECT
  list_select([10, 20, 30, 40], [1, 4]);