Unnest arrays of different dimensions

Question

Is there a function or query that could return arrays of different dimensions as a set? For example, I would like to return the values

ARRAY[1]
ARRAY[2,3]
ARRAY[4,5,6]

as

score 4 · Accepted Answer · edited May 23 '17 at 11:57

4

SELECT unnest(arr) AS elem
FROM (
 VALUES
   (ARRAY[1])
  ,(ARRAY[2,3])
  ,(ARRAY[4,5,6])
  ) t (arr);

Returns as requested.
More details:

edited May 23 '17 at 11:57

Community

answered Aug 06 '14 at 05:06

1

Note that the order of the results isn't guaranteed, though in practice it's consistent. You'll need 9.4's `WITH ORDINALITY` to guarantee it. – Craig Ringer Aug 06 '14 at 06:09
1

@CraigRinger: I added a link to elaborate on that. – Erwin Brandstetter Aug 06 '14 at 06:59

score 0 · Answer 2 · answered Aug 06 '14 at 05:08

0

try the following query

select unnest(a) from
(select array[1] as arr union select array[2,3]
union select array[4,5,6]) t

hopes this may be helpful :) ..

answered Aug 06 '14 at 05:08

Srinu Chinka

2 Answers2