v.23.12Improvement

Function format now supports arbitrary argument types

Official CH changelog text
Function format now supports arbitrary argument types (instead of only String and FixedString arguments). This is important to calculate SELECT format('The {0} to all questions is {1}', 'answer', 42). #57549 (Robert Schulze).
The format function now supports arbitrary argument types beyond just String and FixedString.

Why it matters

This enhancement allows users to use format with mixed argument types, such as integers or other data types, enabling more flexible and convenient string formatting in queries.

How to use it

Use the format function with any argument types in your SQL queries, for example:

sql<br>SELECT format('The {0} to all questions is {1}', 'answer', 42)<br>

Related resources

PreviousNext