{code}
SELECT ARRAY_ELEM(a_double_array, 1) FROM table_with_array.
{code}
Am i right?  So arrays will be accessed with the above syntax and not the normal way 
SELECT a_double_array[1] FROM table_with_array.