CAST_ARR_STR
Written by
Updated at June 27, 2023
Syntax
CAST_ARR_STR( array )
Description
Converts array to an array of strings. The conversion rules are the same as for STR.
Argument types:
array—Array of fractional numbers | Array of integers | Array of strings
Return type: Array of strings
Example
| [int_array] | [float_array] | CAST_ARR_STR([int_array]) | CAST_ARR_STR([float_array]) |
|---|---|---|---|
'[12,0,42]' |
'[12.3,0.43,42]' |
"['12','0','42']" |
"['12.3','0.43','42']" |
'[-3,NULL,0]' |
'[0,NULL,12]' |
"['-3',NULL,'0']" |
"['0',NULL,'12']" |
'[132,637,NULL]' |
'[3.2,2.3,3.5]' |
"['132','637',NULL]" |
"['3.2','2.3','3.5']" |
Data source support
ClickHouse 21.8, PostgreSQL 9.3.