Skip to content

Creates an array containing a specified element repeated N times.

func.array_repeat('x', 3)
func.array_repeat('x', 3)
┌───────────────┐
['x','x','x']
└───────────────┘
ARRAY_REPEAT('x', 3)
SELECT ARRAY_REPEAT('x', 3);
┌───────────────┐
│ ["x","x","x"] │
└───────────────┘