v.19.8New Features

Added Format Function

Official CH changelog text
Added format function. Formatting constant pattern (simplified Python format pattern) with the strings listed in the arguments. #5330 (Danila Kutenin)
Added the format function to ClickHouse, enabling string formatting using simplified Python-like format patterns with provided arguments.

Why it matters

This feature allows users to create formatted strings dynamically within SQL queries, improving flexibility in string manipulation and presentation without external processing.

How to use it

Use the format function by specifying a constant pattern string with placeholders, followed by the values to substitute. For example:
SELECT format('Hello, {}!', 'world')

This will output: 'Hello, world!'.

Related resources

PreviousNext