Text & patterns Scalar Table

repeat()

Repeats the blob count number of times.

Arguments & returns

4 overloads

Scalar

Overload link	`blob`	`count`	Returns
#01	`BLOB`	`BIGINT`	`BLOB`

Scalar

Overload link	`col0`	`col1`	Returns
#02	`T[]`	`BIGINT`	`T[]`

Scalar

Repeats the string count number of times.

Overload link	`string`	`count`	Returns
#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))