ARR_REMOVE
Written by
Updated at November 6, 2024
Syntax
ARR_REMOVE( array, value )
Description
Removes all array elements equal to value.
Argument types:
array—Array of fractional numbers | Array of integers | Array of stringsvalue—Fractional number | Integer | String
Return type: Same type as (array)
Example
| [array] | ARR_REMOVE([array], NULL) |
|---|---|
'[100,300,200,100,300]' |
'[100,300,200,100,300]' |
'[100,300,NULL,NULL]' |
'[100,300]' |
'[150,NULL,130,192]' |
'[150,130,192]' |
Data source support
ClickHouse 21.8, Files, Google Sheets, PostgreSQL 9.3, Yandex Documents.