v.24.1Improvement

Function concatWithSeparator Now Supports Arbitrary Argument Types

Official CH changelog text
Function concatWithSeparator now supports arbitrary argument types (instead of only String and FixedString arguments). For example, SELECT concatWithSeparator('.', 'number', 1) now returns number.1. #59341 (Robert Schulze).
concatWithSeparator function now supports arguments of arbitrary types, not limited to String and FixedString.

Why it matters

Previously, concatWithSeparator only accepted string-type arguments, which limited its usability when combining different data types. This enhancement allows users to concatenate mixed-type arguments seamlessly, improving flexibility and convenience when constructing strings from various data types.

How to use it

Use concatWithSeparator(separator, arg1, arg2, ...) with any argument types. For example:

SELECT concatWithSeparator('.', 'number', 1)

which returns number.1.

Related resources

PreviousNext