| From: | Andreas Joseph Krogh <andreas(at)visena(dot)com> |
|---|---|
| To: | David Rowley <dgrowleyml(at)gmail(dot)com> |
| Cc: | PostgreSQL General <pgsql-general(at)lists(dot)postgresql(dot)org> |
| Subject: | Re: array_cat in PG-14 changed signature breaks my custom aggregate |
| Date: | 2021-05-24 10:35:44 |
| Message-ID: | VisenaEmail.27.ff48e25932972352.1799df16847@tc7-visena |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
På mandag 24. mai 2021 kl. 12:01:44, skrev David Rowley <dgrowleyml(at)gmail(dot)com
<mailto:dgrowleyml(at)gmail(dot)com>>:
[..]
> Do I have to change the signature of my aggregate to take
anycompatiblearray as argument?
Yeah you'll need to do that or write your own transition function that
takes an anyarray. The docs mention:
"the sfunc must take N+1 arguments, the first being of type state_data_type"
array_cat no longer takes anyarray.
regression=# \dfS array_cat
List of functions
Schema | Name | Result data type | Argument data
types | Type
------------+-----------+--------------------+----------------------------------------+------
pg_catalog | array_cat | anycompatiblearray | anycompatiblearray,
anycompatiblearray | func
(1 row)
This was changed in [1].
David
Ok, thanks.
--
Andreas Joseph Krogh
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Peter J. Holzer | 2021-05-24 10:46:23 | Re: The contents of the pg_timezone_names view bring some surprises |
| Previous Message | David Rowley | 2021-05-24 10:01:44 | Re: array_cat in PG-14 changed signature breaks my custom aggregate |