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