Functions/Lists & arrays/array_where
Lists & arrays Scalar

array_where()

Returns a list with the BOOLEANs in mask_list applied as a mask to the value_list.

Alias of list_where()

Arguments & returns

array_where(value_list, mask_list)

Scalar
Overload link value_listmask_list Returns
#01 ANY[]BOOLEAN[] ANY[]

Example

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

Engine example · Run to view results.

Catalog examples

SELECT
  list_where([10, 20, 30, 40], [true, false, false, true]);