Thread: aggregate array broken in postgresql 15.
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)
------------------------------------------------------------------------------------------------------------------------------------------------------------------------
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
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?
Hi
čt 7. 4. 2022 v 12:30 odesílatel alias <postgres.rocks@gmail.com> napsal:
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 tested your code on my clean pg 15 without any problem
Maybe you have an array_agg_mult with anyarray argument. If yes, then you have to drop this aggregate function.
Regards
Pavel
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?
my mistake. I don't know that aggregate can also overload. problem solved....
On Thu, Apr 7, 2022 at 4:09 PM Pavel Stehule <pavel.stehule@gmail.com> wrote:
Hičt 7. 4. 2022 v 12:30 odesílatel alias <postgres.rocks@gmail.com> napsal: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 msI tested your code on my clean pg 15 without any problemMaybe you have an array_agg_mult with anyarray argument. If yes, then you have to drop this aggregate function.RegardsPavelI 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?