From: Tom Lane <tgl@sss.pgh.pa.us>
To: Pavel Stehule <pavel.stehule@gmail.com>
Cc: David Turoň <Turon.David@seznam.cz>
Cc: edouard.hibon@free.fr, PostgreSQL mailing lists <pgsql-bugs@lists.postgresql.org>
Cc: David G. Johnston <david.g.johnston@gmail.com>
Subject: Re: BUG #17206: the function array_cat(anyarray, anyarray) does not exist
Date: Thu, 11 Aug 2022 09:53:33 -0400
Message-ID: <482921.1660226013@sss.pgh.pa.us> (raw)
In-Reply-To: <CAFj8pRCnxTiCBUCM1OsBdpUq1YsioeHb2EMyHRp8c9rYbKE+zA@mail.gmail.com>
References: <CAKFQuwbKPYOuaexih1fMDPKa7kTjLSVjNdWCRHn7iJ2+oukpHg@mail.gmail.com>
<17206-f0a6b77a0a7b8499@postgresql.org>
<3266664.1633045937@sss.pgh.pa.us>
<13T.5{S3.6C2WnHnPYu}.1YzDSc@scif.cz>
<CAFj8pRCnxTiCBUCM1OsBdpUq1YsioeHb2EMyHRp8c9rYbKE+zA@mail.gmail.com>
Pavel Stehule <pavel.stehule@gmail.com> writes:
> čt 11. 8. 2022 v 12:17 odesílatel David Turoň <Turon.David@seznam.cz>
> napsal:
>> Is bug that function with anycompatiblearray didn't accept anyarray data
>> type?
> and yes - anyarray type is distinct from anycompatiblearray
> so you can write
> create or replace function fx(anyarray, anyarray, anycompatiblearray,
> anycompatiblearray) that means
Yeah. We could introduce a cast from anyarray to anycompatiblearray,
but I fear it'd play hob with the ability to use both polymorphic
families in one function signature.
More to the point, though, the casts are required here in any case.
Pre-v14, you got a different error, but it was still an error.
Neither in principle nor in practice would it be safe to pass
pg_stats.most_common_vals to array_position() without any cast.
array_position expects the array's element type to match the type
of its second argument, and will probably crash if it doesn't.
So forcing most_common_vals to flat text and then to text[] is
essential to unify the incompatible types found in pg_stat.
regards, tom lane
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-bugs@postgresql.org
Cc: tgl@sss.pgh.pa.us, pavel.stehule@gmail.com, Turon.David@seznam.cz, pgsql-bugs@lists.postgresql.org, david.g.johnston@gmail.com
Subject: Re: BUG #17206: the function array_cat(anyarray, anyarray) does not exist
In-Reply-To: <482921.1660226013@sss.pgh.pa.us>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox