REPEAT

​

Syntax

​

Scalar

repeat(value, count)

​

Arguments

​

Returns

• Type: STRING
• Possible values: The concatenation of count copies; an empty string when count is zero or negative.
• NULL behavior: Returns NULL if either argument is NULL.

​

Properties

​

Examples

​

Typical behavior

SELECT repeat('ab', 3) AS repeated, repeat('ab', -1) AS negative;

​

Repeat Unicode text

SELECT repeat('猫', 2) AS repeated, repeat('cat', 0) AS zero_repetitions;

​

Limitations

• A result exceeding the string storage limit raises an execution error. Large requested values can require substantial memory.