Text & patterns Scalar Table

repeat()

Repeats the string count number of times

Arguments & returns

4 overloads

Scalar

Overload link	`string`	`count`	Returns
#01	`ANY[]`	`BIGINT`	`ANY[]`
#02	`BLOB`	`BIGINT`	`BLOB`
#03	`VARCHAR`	`BIGINT`	`VARCHAR`

Table

Overload link	`col0`	`col1`	Returns
#04	`ANY`	`BIGINT`	`TABLE`

SELECT repeat('\xAA\xBB'::BLOB, 5);

Haybarn WASM 1.5.5-rc3 · In your browser

Engine example · Run to view results.

SELECT repeat('A', 5);

Haybarn WASM 1.5.5-rc3 · In your browser

Engine example · Run to view results.

SELECT SPACE(5)

In DuckDB

SELECT REPEAT(' ', CAST(5 AS BIGINT))