PotgreSQL 2D array to rows
- by PostGreSQL newbie
Hello,
I am new to PostgreSQL array's.
I am trying to a write a procedure to convert array-into-rows,
and wanted following output:
alphabet | number
---------+----------
A | 10
B | 10
C | 6
D | 9
E | 3
from following:
id | alphabet_series
-------+--------------------------------------------------------------------------------------------------
1 | {{A,10},{B,10},{C,6},{D,9},{E,3},{F,9},{I,10},{J,17},{K,16},{L,17},{M,20},{N,13},{O,19}}
I have searched for array-to-rows functions, but they all seems to accept 1-d array.
but in this case, it is 2-d array.
Any pointers will be appreciated.
Many thanks.
