Thomas Kellerer <spam_ea...@gmx.net> writes: > Maybe I am missing something, but: > select id, data[1], data[2] > from the_table; > will work just fine.
If the arrays are of varying length, unnest() might be what the OP is looking for. regards, tom lane