På mandag 24. mai 2021 kl. 12:01:44, skrev David Rowley <dgrowle...@gmail.com 
<mailto:dgrowle...@gmail.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

 [1] 
https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=9e38c2bb5093ceb0c04d6315ccd8975bd17add66


Ok, thanks. 



-- 
Andreas Joseph Krogh 

Reply via email to