On 2021-05-23 12:55:52 -0700, Bryn Llewellyn wrote:
> But it doesn't necessarily error when presented with a key that it
> doesn't have. This, too, has been discussed at length in this
> exchanges. These examples make the point.
>
> set timezone = 'UTC';
> select '2021-05-23 19:00:00 foo42bar'::ti
På mandag 24. mai 2021 kl. 12:01:44, skrev David Rowley 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:
On Mon, 24 May 2021 at 20:53, Andreas Joseph Krogh wrote:
>
> Hi, I have this, for historical reasons:
>
> CREATE AGGREGATE array_aggarray(anyarray) (
> SFUNC = array_cat, STYPE = anyarray);
>
>
> ...which now breaks in pg-14b1:
>
> ERROR: function array_cat(anyarray, anyarray) does not exist
Hi, I have this, for historical reasons:
CREATE AGGREGATE array_aggarray(anyarray) (
SFUNC = array_cat, STYPE = anyarray);
...which now breaks in pg-14b1:
ERROR: function array_cat(anyarray, anyarray) does not exist
I see the argument data-types have changed from anyarray to
anycompa