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

From Jim Nasby
Subject Re: Disallow arrays with non-standard lower bounds
Date
Msg-id 52D0656C.60702@nasby.net
Whole thread Raw
In response to Re: Disallow arrays with non-standard lower bounds  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Disallow arrays with non-standard lower bounds  (Andrew Dunstan <andrew@dunslane.net>)
Re: Disallow arrays with non-standard lower bounds  (David Fetter <david@fetter.org>)
Re: Disallow arrays with non-standard lower bounds  (Jeff Janes <jeff.janes@gmail.com>)
List pgsql-hackers
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
vs1 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?
 
-- 
Jim C. Nasby, Data Architect                       jim@nasby.net
512.569.9461 (cell)                         http://jim.nasby.net



pgsql-hackers by date:

Previous
From: Heikki Linnakangas
Date:
Subject: Re: INSERT...ON DUPLICATE KEY LOCK FOR UPDATE
Next
From: David Rowley
Date:
Subject: Re: [PATCH] Negative Transition Aggregate Functions (WIP)