On 15 March 2014 16:21, Tom Lane <tgl@sss.pgh.pa.us> wrote:
> "Raymond O'Donnell" <rod@iol.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