Re: Support for array_remove and array_replace functions
Alex Hunsaker <badalex@gmail.com>
From: Alex Hunsaker <badalex@gmail.com>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: Marco Nenciarini <marco.nenciarini@2ndquadrant.it>, PostgreSQL-development <pgsql-hackers@postgresql.org>
Date: 2012-07-11T16:53:52Z
Lists: 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.