Concatenate array elements in order PostgreSQL

Question

Is it possible to concatenate elements of 2 arrays in the correct order of its elements?

Example:

array1=['a','b','c']
array2=['d','e','f']

concatenated_array=['ad','be','cf']

My data is in the following way:

id           col1              col2
1        ['a','b','c']     ['d','e','f']
2        ['g','h','i']     ['j','k','l']
3        ['a','b','c']     ['j','k','l']

Just a hint: select coalesce(x||y,x,y) from unnest('{1,null,3}'::varchar[], '{a,b}'::varchar[]) t(x,y); — Abelisto
– Abelisto, Commented Mar 22, 2016 at 18:55

Evgeniy Chekan · Accepted Answer · 2016-03-22 18:55:08Z

3

Use array_agg and unnest (with column alias).

SELECT array_agg(el1||el2)
FROM unnest(ARRAY['a','b','c'], ARRAY['d','e','f']) el (el1, el2);

 array_agg  
------------
 {ad,be,cf}
(1 row)

answered Mar 22, 2016 at 18:55

Evgeniy Chekan

2,6651 gold badge17 silver badges23 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Concatenate array elements in order PostgreSQL

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related