Re: Support for array_remove and array_replace functions - Mailing list pgsql-hackers

From Alex Hunsaker
Subject Re: Support for array_remove and array_replace functions
Date
Msg-id CAFaPBrQasSqBUbp1s85YwmKLJzWRRE1ie4D5_u4cgSkpfJLy3w@mail.gmail.com
Whole thread Raw
In response to Re: Support for array_remove and array_replace functions  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Support for array_remove and array_replace functions
Re: Support for array_remove and array_replace functions
List pgsql-hackers
On Wed, Jul 11, 2012 at 9:54 AM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
> Marco Nenciarini <marco.nenciarini@2ndquadrant.it> writes:
>> Patch v3 attached.
>
> I'm looking at this patch now.  The restriction of array_remove to
> one-dimensional arrays seems a bit annoying.  I see the difficulty:
> if the input is multi-dimensional then removing some elements could
> lead to a non-rectangular array, which isn't supported.  However,
> that could be dealt with by decreeing that the *result* is
> one-dimensional and of the necessary length, regardless of the
> dimensionality of the input.

Makes sense to me. +1

The other option ISTM is to replace removed entries with NULL-- which
I don't really like.


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: Support for array_remove and array_replace functions
Next
From: Tom Lane
Date:
Subject: Re: Support for array_remove and array_replace functions