| From: | Gavin Flower <GavinFlower(at)archidevsys(dot)co(dot)nz> |
|---|---|
| To: | Kevin Grittner <kgrittn(at)ymail(dot)com> |
| Cc: | Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com>, Florian Pflug <fgp(at)phlo(dot)org>, Andrew Dunstan <andrew(at)dunslane(dot)net>, Robert Haas <robertmhaas(at)gmail(dot)com>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Brendan Jurd <direvus(at)gmail(dot)com>, Josh Berkus <josh(at)agliodbs(dot)com>, PostgreSQL Hackers <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: [PATCH] Exorcise "zero-dimensional" arrays (Was: Re: Should array_length() Return NULL) |
| Date: | 2013-04-03 19:03:03 |
| Message-ID: | 515C7CE7.40801@archidevsys.co.nz |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
On 04/04/13 07:58, Kevin Grittner wrote:
> Gavin Flower <GavinFlower(at)archidevsys(dot)co(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jeff Davis | 2013-04-03 19:15:53 | Re: regression test failed when enabling checksum |
| Previous Message | Kevin Grittner | 2013-04-03 18:58:37 | Re: [PATCH] Exorcise "zero-dimensional" arrays (Was: Re: Should array_length() Return NULL) |