Functions/Lists & arrays/array_to_string
Lists & arrays Macro

array_to_string()

Arguments & returns

array_to_string(arr, sep)

Macro
Overload link arrsep Returns
#01 unknownunknown unknown

Definition

CASE
  WHEN ((len(CAST(arr AS VARCHAR[])) = 0)) THEN ('')
  ELSE list_aggr(CAST(arr AS VARCHAR[]), 'string_agg', sep)
END

In other engines

PostgreSQLarray_to_string()

Same function

Apache Sparkarray_join()

ARRAY_JOIN(arr, delim)
In DuckDB
ARRAY_TO_STRING(arr, delim)

SQLGlot example ↗

BigQueryarray_to_string()

Same function

Prestoarray_join()

ARRAY_JOIN(arr, delim)
In DuckDB
ARRAY_TO_STRING(arr, delim)

SQLGlot example ↗

Used in larger rewrites 1

These examples use array_to_string as one part of a larger SQL translation.

Snowflakearray_to_string()

SELECT ARRAY_TO_STRING(x, '')
In DuckDB
SELECT CASE WHEN '' IS NULL THEN NULL ELSE ARRAY_TO_STRING(LIST_TRANSFORM(x, x -> COALESCE(CAST(x AS TEXT), '')), '') END

SQLGlot example ↗