Received: from malur.postgresql.org ([217.196.149.56])
	by arkaria.postgresql.org with esmtps
 (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256)
	(Exim 4.92)
	(envelope-from <pgsql-committers-owner+archive@lists.postgresql.org>)
	id 1kcs0N-0002he-Ed
	for pgsql-committers@arkaria.postgresql.org; Wed, 11 Nov 2020 15:25:51 +0000
Received: from localhost ([127.0.0.1] helo=malur.postgresql.org)
	by malur.postgresql.org with esmtp (Exim 4.92)
	(envelope-from <pgsql-committers-owner+archive@lists.postgresql.org>)
	id 1kcs0L-0006zY-3u
	for pgsql-committers@arkaria.postgresql.org; Wed, 11 Nov 2020 15:25:49 +0000
Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29])
	by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256)
	(Exim 4.92)
	(envelope-from <andrew@dunslane.net>)
	id 1kcs0K-0006zQ-UZ
	for pgsql-committers@lists.postgresql.org; Wed, 11 Nov 2020 15:25:48 +0000
Received: from relay3-d.mail.gandi.net ([217.70.183.195])
	by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256)
	(Exim 4.92)
	(envelope-from <andrew@dunslane.net>)
	id 1kcs0G-0003xb-B1
	for pgsql-committers@lists.postgresql.org; Wed, 11 Nov 2020 15:25:48 +0000
X-Originating-IP: 99.10.92.30
Received: from [192.168.10.146] (99-10-92-30.lightspeed.rlghnc.sbcglobal.net
 [99.10.92.30])
	(Authenticated sender: adsend@dunslane.net)
	by relay3-d.mail.gandi.net (Postfix) with ESMTPSA id 121DF60003;
	Wed, 11 Nov 2020 15:25:40 +0000 (UTC)
Subject: Re: pgsql: Declare assorted array functions using anycompatible not
 anyelem
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: pgsql-committers@lists.postgresql.org
References: <E1kaQ2c-0005lx-Eg@gemulon.postgresql.org>
 <fff35eb5-765c-3e60-3a2a-45ba5f88777d@dunslane.net>
 <1999748.1604957386@sss.pgh.pa.us>
 <b300679b-6410-9124-271c-73893a2c3a1f@dunslane.net>
 <2001798.1604960149@sss.pgh.pa.us>
 <52030649-c25c-c4e6-8316-2fd4f9a24f8b@dunslane.net>
 <2008195.1604961694@sss.pgh.pa.us>
 <dc77bfb2-3b98-c3e5-a825-6c087d51f51c@dunslane.net>
 <2255607.1605040303@sss.pgh.pa.us>
From: Andrew Dunstan <andrew@dunslane.net>
Message-ID: <9f28c003-38a7-96c9-300d-b11e39fb5491@dunslane.net>
Date: Wed, 11 Nov 2020 10:25:38 -0500
User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:78.0) Gecko/20100101
 Thunderbird/78.3.1
MIME-Version: 1.0
In-Reply-To: <2255607.1605040303@sss.pgh.pa.us>
Content-Type: text/plain; charset=windows-1252
Content-Transfer-Encoding: 7bit
Content-Language: en-US
List-Id: <pgsql-committers.lists.postgresql.org>
List-Help: <https://lists.postgresql.org/manage/>
List-Subscribe: <https://lists.postgresql.org/manage/>
List-Post: <mailto:pgsql-committers@lists.postgresql.org>
List-Owner: <mailto:pgsql-committers-owner@lists.postgresql.org>
List-Archive: <https://www.postgresql.org/list/pgsql-committers>
Precedence: bulk


On 11/10/20 3:31 PM, Tom Lane wrote:
> Andrew Dunstan <andrew@dunslane.net> writes:
>> On 11/9/20 5:41 PM, Tom Lane wrote:
>>> What I have in mind to apply to 9.5 through 13 is per attached.
>> You also need to modify first_el_agg_any.
> ... doh.  That one is a little messier because there's no equally useful
> substitute function.  What I'm inclined to do for that is to add a
> SQL-language wrapper to reproduce the old signature for array_append.
> As attached.  (I'm keeping this separate from the other patch, since
> this doesn't go back as far.)
>
>

Seems reasonable.


cheers


andrew