Wednesday, 7 August 2013

PostgreSQL: Convert multi-dimensional array to records

PostgreSQL: Convert multi-dimensional array to records

Given: {{1,"a"},{2,"b"},{3,"c"}}
Desired:
foo | bar
-----+------
1 | a
2 | b
3 | c
It seems unnesting returns a single-column recordset, which isn't desired

No comments:

Post a Comment