Re: Multi-dimensional arrays

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Thom Brown <thom(at)linux(dot)com>
Cc: rod <rod(at)iol(dot)ie>, PostgreSQL <pgsql-general(at)postgresql(dot)org>
Subject: Re: Multi-dimensional arrays
Date: 2014-03-15 17:08:58
Message-ID: 21932.1394903338@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Thom Brown <thom(at)linux(dot)com> writes:
> On 15 March 2014 16:21, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Reece Hart 2014-03-15 20:57:40 datomic db as foreign data wrapper?
Previous Message Thom Brown 2014-03-15 17:07:11 Re: Multi-dimensional arrays