REPEAT
All functions > ARRAY > REPEAT
Creates an array by repeating an element a specified number of times.
Signatures
Returns: Array with the element repeated count times
REPEAT(element: T, count: BIGINT) → ARRAY<T>sql
| Parameter | Type | Required | Description |
|---|---|---|---|
element | T | Yes | The element to repeat |
count | BIGINT | Yes | Number of times to repeat the element |
Notes
- Creates array with same element repeated multiple times
- Count must be non-negative
- Returns empty array if count is 0
- Useful for generating test data or default values
- Generic type: (T, BIGINT) → Array(T)
On this page