On 15 March 2014 16:21, Tom Lane <tgl@xxxxxxxxxxxxx> wrote: > "Raymond O'Donnell" <rod@xxxxxx> 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 -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
