Re: array_cat in PG-14 changed signature breaks my custom aggregate

Поиск
Список
Период
Сортировка
От Andreas Joseph Krogh
Тема Re: array_cat in PG-14 changed signature breaks my custom aggregate
Дата
Msg-id VisenaEmail.27.ff48e25932972352.1799df16847@tc7-visena
обсуждение исходный текст
Ответ на Re: array_cat in PG-14 changed signature breaks my custom aggregate  (David Rowley <dgrowleyml@gmail.com>)
Список pgsql-general
På mandag 24. mai 2021 kl. 12:01:44, skrev David Rowley <dgrowleyml@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

В списке pgsql-general по дате отправления:

Предыдущее
От: David Rowley
Дата:
Сообщение: Re: array_cat in PG-14 changed signature breaks my custom aggregate
Следующее
От: "Peter J. Holzer"
Дата:
Сообщение: Re: The contents of the pg_timezone_names view bring some surprises