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

From: Josh Berkus <josh(at)agliodbs(dot)com>
To: pgsql-hackers(at)postgresql(dot)org
Subject: Re: [PATCH] Exorcise "zero-dimensional" arrays (Was: Re: Should array_length() Return NULL)
Date: 2013-03-25 02:02:55
Message-ID: 514FB04F.5050904@agliodbs.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On 03/20/2013 04:45 PM, Brendan Jurd wrote:
> Incompatibility:
> This patch introduces an incompatible change in the behaviour of the
> aforementioned array functions -- instead of returning NULL for empty
> arrays they return meaningful values. Applications relying on the old
> behaviour to test for emptiness may be disrupted. One can

As a heavy user of arrays, I support this patch as being worth the
breakage of backwards compatibility. However, that means it certainly
will need to wait for 9.4 to provide adequate warning.

Brendan, how hard would it be to create a GUC for backwards-compatible
behavior?

--
Josh Berkus
PostgreSQL Experts Inc.
http://pgexperts.com

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Greg Smith 2013-03-25 02:50:48 Re: Limiting setting of hint bits by read-only queries; vacuum_delay
Previous Message Nicholas White 2013-03-25 00:15:10 Re: Request for Patch Feedback: Lag & Lead Window Functions Can Ignore Nulls