Text & patterns Scalar Table

repeat()

Repeats the blob count number of times.

Reference: DuckDB 2.0.0

Arguments & returns

4 overloads

repeat(blob, count)

Scalar
Overload link blobcount Returns
#01 BLOBBIGINT BLOB

repeat(list, count)

Scalar
Overload link listcount Returns
#02 T[]BIGINT T[]

repeat(string, count)

Scalar

Repeats the string count number of times.

Overload link stringcount Returns
#03 VARCHARBIGINT VARCHAR

repeat(value, count)

Table
Overload link valuecount Returns
#04 ANYBIGINT TABLE
repeat example
SQL
Haybarn WASM 2.0.0-rc12 · In your browser

Engine example · Run to view results.

More examples

repeat example 2
SQL
Haybarn WASM 2.0.0-rc12 · In your browser

Engine example · Run to view results.

In other engines

Snowflakespace()

SELECT SPACE(5)
In DuckDB
SELECT REPEAT(' ', CAST(5 AS BIGINT))

SQLGlot example ↗