On 01/10/2014 04:26 PM, Jim Nasby wrote:
On 1/9/14, 10:58 PM, Tom Lane wrote:
Jim Nasby <j...@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).
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
