Re: Disallow arrays with non-standard lower bounds - Mailing list pgsql-hackers

From Jeff Janes
Subject Re: Disallow arrays with non-standard lower bounds
Date
Msg-id CAMkU=1xsPanD5PbQwybcFmuWdYc=1F+xmFZokC2z5hbuXXOBPQ@mail.gmail.com
Whole thread Raw
In response to Re: Disallow arrays with non-standard lower bounds  (Jim Nasby <jim@nasby.net>)
Responses Re: Disallow arrays with non-standard lower bounds  (Merlin Moncure <mmoncure@gmail.com>)
List pgsql-hackers
On Fri, Jan 10, 2014 at 1:26 PM, Jim Nasby <jim@nasby.net> wrote:
On 1/9/14, 10:58 PM, Tom Lane wrote:
Jim Nasby <jim@nasby.net> writes:
ISTM that allowing users to pick arbitrary lower array bounds was a huge mistake. I've never seen anyone make use of it, can't think of any legitimate use cases for it, and hate the stupendous amount of extra code needed to deal with it.

You lack imagination, sir.

Considering what you'd normally want to do in SQL, the only example I can think of is to not have the argument over 0 vs 1 based.

Actually, I was thinking there might be some computational problems where changing lower bound would be nice, but then again, what other languages actually support this?

Perl does, though they regret it bitterly.

Cheers,

Jeff

pgsql-hackers by date:

Previous
From: Kevin Grittner
Date:
Subject: Re: Disallow arrays with non-standard lower bounds
Next
From: Merlin Moncure
Date:
Subject: Re: Disallow arrays with non-standard lower bounds