Postgres Pro
Downloads
Home   >   mailing lists

Re: BUG #17206: the function array_cat(anyarray, anyarray) does not exist - Mailing list pgsql-bugs

From David G. Johnston
Subject Re: BUG #17206: the function array_cat(anyarray, anyarray) does not exist
Date
Msg-id CAKFQuwbKPYOuaexih1fMDPKa7kTjLSVjNdWCRHn7iJ2+oukpHg@mail.gmail.com
Whole thread Raw
In response to BUG #17206: the function array_cat(anyarray, anyarray) does not exist  (PG Bug reporting form <noreply@postgresql.org>)
Responses Re: BUG #17206: the function array_cat(anyarray, anyarray) does not exist  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-bugs
Tree view
On Thu, Sep 30, 2021 at 2:51 PM PG Bug reporting form <noreply@postgresql.org> wrote:
The following bug has been logged on the website:

Bug reference:      17206
Logged by:          Edouard HIBON
Email address:      edouard.hibon@free.fr
PostgreSQL version: 14.0
Operating system:   windows 10
Description:       

Trying to create the following aggregate function :
CREATE AGGREGATE array_accum (anyarray)
(
    sfunc = array_cat,
    stype = anyarray,
    initcond = '{}'
);

I get the ERROR : the function array_cat(anyarray, anyarray) does not exist,
SQL state: 42883
whereas this works in PostGreSQL 13.4

You may find this commit to be illuminating.  Work was done in this area for v14.

https://github.com/postgres/postgres/commit/97f73a978fc1aca59c6ad765548ce0096d95a923

David J.

pgsql-bugs by date:

Previous
From: PG Bug reporting form
Date:
Subject: BUG #17206: the function array_cat(anyarray, anyarray) does not exist
Next
From: PG Bug reporting form
Date:
Subject: BUG #17207: Bad cost estimate of Merge Join despite correct row estimate