From: | alias <postgres(dot)rocks(at)gmail(dot)com> |
---|---|
To: | pgsql-hackers(at)lists(dot)postgresql(dot)org |
Subject: | aggregate array broken in postgresql 15. |
Date: | 2022-04-07 10:30:21 |
Message-ID: | CAJA4AWTfmSQ5OyPZod6hWVp0Jk0PbHXNi=4UWYLg6Te+GWAi1g@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
https://github.com/postgres/postgres/commit/97f73a978fc1aca59c6ad765548ce0096d95a923?diff=split
https://dbfiddle.uk/?rdbms=postgres_14&fiddle=11a30590cb376a24df172198139d758e
select version();
version
------------------------------------------------------------------------------------------------------------------------------------------------------------------------
PostgreSQL 15devel (Ubuntu
15~~devel~20220329.1030-1~680.git8cd7627.pgdg20.04+1) on
x86_64-pc-linux-gnu, compiled by gcc (Ubuntu 9.4.0-1ubuntu1~20.04.1) 9.4.0,
64-bit
(1 row)
(END)
----------------
create or replace aggregate array_agg_mult(anycompatiblearray) (
sfunc = array_cat,
stype = anycompatiblearray,
initcond = '{}'
);
SELECT array_agg_mult(i)
FROM (VALUES (ARRAY[row(1,2),row(3,4)]), (ARRAY[row(5,6),row(7,8)])) as t(i);
ERROR: 42725: function array_agg_mult(record[]) is not unique
LINE 1: SELECT array_agg_mult(i)
^
HINT: Could not choose a best candidate function. You might need to add
explicit type casts.
LOCATION: ParseFuncOrColumn, parse_func.c:570
Time: 1.292 ms
I installed postgresql 15, one week ago.
How to solve the above mentioned problem. Or since it was solved last week,
I need to update postgresql?
From | Date | Subject | |
---|---|---|---|
Next Message | Aleksander Alekseev | 2022-04-07 10:35:02 | Re: Unit tests for SLRU |
Previous Message | Amit Kapila | 2022-04-07 10:27:54 | Re: Skipping logical replication transactions on subscriber side |