repeat()
Repeats the blob count number of times.
Reference: DuckDB 2.0.0
Arguments & returns
4 overloadsrepeat(blob, count)
Scalar
| Overload link | blob | count |
Returns |
|---|---|---|---|
| #01 | BLOB | BIGINT |
BLOB |
repeat(list, count)
Scalar
| Overload link | list | count |
Returns |
|---|---|---|---|
| #02 | T[] | BIGINT |
T[] |
repeat(string, count)
Scalar
Repeats the string count number of times.
| Overload link | string | count |
Returns |
|---|---|---|---|
| #03 | VARCHAR | BIGINT |
VARCHAR |
repeat(value, count)
Table
| Overload link | value | count |
Returns |
|---|---|---|---|
| #04 | ANY | BIGINT |
TABLE |
Example
1 more ↓Haybarn WASM 2.0.0-rc12 · In your browser
Engine example · Run to view results.
More examples
Haybarn WASM 2.0.0-rc12 · In your browser
Engine example · Run to view results.
In other engines
Snowflakespace()
SELECT SPACE(5)
SELECT REPEAT(' ', CAST(5 AS BIGINT))