Skip to main content

ARRAY_APPEND

Prepends an element to the array.

Syntax

ARRAY_APPEND( <array>, <element>)

Examples

SELECT ARRAY_APPEND([3, 4], 5);

┌─────────────────────────┐
│ array_append([3, 4], 5)
├─────────────────────────┤
[3,4,5]
└─────────────────────────┘
Explore Databend Cloud for FREE
Low-cost
Fast Analytics
Easy Data Ingestion
Elastic Scaling
Try it today