On 01/10/2014 04:26 PM, Jim Nasby 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?
Ada, for one. In fact, in Ada the index doesn't need to be an integer,
just an enumerable type (e.g. an enum). You can iterate over
one-dimensional arrays by saying:
FOR i IN [REVERSE] my_array'range LOOP ...
cheers
andrew (who sadly hasn't used Ada in anger for about 20 years).