Re: Multi-dimensional arrays - Mailing list pgsql-general

From Tom Lane
Subject Re: Multi-dimensional arrays
Date
Msg-id 21932.1394903338@sss.pgh.pa.us
Whole thread Raw
In response to Re: Multi-dimensional arrays  (Thom Brown <thom@linux.com>)
List pgsql-general
Thom Brown <thom@linux.com> writes:
> On 15 March 2014 16:21, Tom Lane <tgl@sss.pgh.pa.us> wrote:
>> 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?

GUCs that change application-visible semantics are dangerous; they are
not generally a good way out of tight spots.

            regards, tom lane


pgsql-general by date:

Previous
From: Thom Brown
Date:
Subject: Re: Multi-dimensional arrays
Next
From: Reece Hart
Date:
Subject: datomic db as foreign data wrapper?