- Categories:
String & binary functions (General)
REPEAT¶
Builds a string by repeating the input for the specified number of times.
Syntax¶
REPEAT(<input>, <n>)
Arguments¶
inputThe input string from which the output string is built.
nThe number of times the input string should be repeated. The minimum valid number is 0 (which results in an empty string).
Examples¶
SELECT REPEAT('xy', 5);
-----------------+
REPEAT('XY', 5) |
-----------------+
xyxyxyxyxy |
-----------------+