CAST_ARR_STR

    Syntax

    CAST_ARR_STR( array )
    

    Description

    Converts array to an array of strings. The conversion rules are the same as for STR.

    Argument types:

    • arrayArray 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 19.13, PostgreSQL 9.3.