Hi čt 7. 4. 2022 v 12:30 odesílatel alias <postgres.ro...@gmail.com> napsal:
> > 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 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? > >
