Re: [PATCH] Exorcise "zero-dimensional" arrays (Was: Re: Should array_length() Return NULL)

On 04/04/13 07:58, Kevin Grittner wrote:
> Gavin Flower <GavinFlower@archidevsys.co.nz> wrote:
>
>> Anyhow, I think we should standardise on zero as the initial
>> index to be as consistent as practicable.
> If you want to suggest a default of zero for the first subscript of
> an array in SQL, please don't confuse the issue by using any form
> of the word "standard" in that proposal.  There are ANSI and ISO
> standards for SQL, and they require that the first element of an
> array is one.  I'm OK with *extending* the standard by *allowing*
> other values, but let's not flaunt the standard and break existing
> code by changing the *default*.
>
> --
> Kevin Grittner
> EnterpriseDB: http://www.enterprisedb.com
> The Enterprise PostgreSQL Company
You omitted my rider 'However, not with a religious zeal at the expense 
of practical considerations!' Which was meant to cover concerns like yours.


Cheers,
Gavin