How convert array elements to rows?

sigra

I need to convert array elements to rows. Suppose that I have the array {5,77,39,19}. I need it as a table with the index in one column and the element in the other column:

Expand|Select|Wrap|Line Numbers

 index | element

------+--------

    1 |       5

    2 |      77

    3 |      39

    4 |      19

Which command does this?

rski

Maybe like that

Expand|Select|Wrap|Line Numbers

 
rski=> select i, (ARRAY[11,22,33])[i] from generate_series(1,array_upper(ARRAY[11,22,33],1)) i;

 i | array

---+-------

 1 |    11

 2 |    22

 3 |    33

(3 rows)

If you know the dimension of a table you can replace array_upper with it.

How convert array elements to rows?

re: How convert array elements to rows?

/bytes/development

/bytes/it

/bytes/about