On 15 March 2014 16:21, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
> "Raymond O'Donnell" <rod(at)iol(dot)ie> writes:
>> True... though that gives you a 2D array, whereas I was hoping for a 1D
>> array from (array[...])[1].
>
> Postgres does not think of multi-D arrays as being arrays of arrays.
> This is problematic mainly because the SQL standard does think of them
> that way. I'm not sure if there's any hope of changing it though ---
> there's probably too much code that would be broken if we did.
Could we potentially introduce a GUC to get it to behave in a less
surprising way, and eventually make it the default?
--
Thom