Thomas Kellerer <spam_eater@xxxxxxx> 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
