Concatenate two arrays : Concatenate Array « Array « PostgreSQL
- PostgreSQL
- Array
- Concatenate Array
Concatenate two arrays
postgres=#
postgres=#
postgres=# SELECT ARRAY[1,2] || ARRAY[3,4];
?column?
-----------
{1,2,3,4}
(1 row)
postgres=#
Related examples in the same category
1. | Concatenate two dimensional arrays | | |
2. | array_dims(1 || ARRAY[2,3]) | | |
3. | array_dims(ARRAY[1,2] || 3) | | |
4. | array_dims(ARRAY[1,2] || ARRAY[3,4,5]) | | |
5. | array_dims(ARRAY[[1,2],[3,4]] || ARRAY[[5,6],[7,8],[9,0]]) | | |
6. | array_dims(ARRAY[1,2] || ARRAY[[3,4],[5,6]]) | | |