Postgres Pro
Downloads
Home   >   mailing lists

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

From Josh Berkus
Subject Re: [PATCH] Exorcise "zero-dimensional" arrays (Was: Re: Should array_length() Return NULL)
Date
Msg-id 514FB04F.5050904@agliodbs.com
Whole thread Raw
In response to [PATCH] Exorcise "zero-dimensional" arrays (Was: Re: Should array_length() Return NULL)  (Brendan Jurd <direvus@gmail.com>)
Responses Re: [PATCH] Exorcise "zero-dimensional" arrays (Was: Re: Should array_length() Return NULL)  (Brendan Jurd <direvus@gmail.com>)
Re: [PATCH] Exorcise "zero-dimensional" arrays (Was: Re: Should array_length() Return NULL)  (Robert Haas <robertmhaas@gmail.com>)
List pgsql-hackers
Tree view 
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

pgsql-hackers by date:

Previous
From: Nicholas White
Date:
Subject: Re: Request for Patch Feedback: Lag & Lead Window Functions Can Ignore Nulls
Next
From: Greg Smith
Date:
Subject: Re: Limiting setting of hint bits by read-only queries; vacuum_delay