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