- Overview
- Data types
- Commands
- Functions
- Overview
- Aggregate
- Conditional expression
- Conversion
- Date and time
- Numeric
- String
- Semi-structured data
- Window
- System
On this page
repeat
Repeats a string.
Syntax
repeat( <expr>, n => <count> )
Arguments
<expr> is a string expression.
n is a non-negative integer repeat count.
Returns
Returns a string.
Examples
SELECT repeat('ha', n => 3);