select arraymultirange(arrayrange(array[1,2], array[2,1]));

ERROR:  42883: function arrayrange(integer[], integer[]) does not exist
> LINE 1: select arraymultirange(arrayrange(array[1,2], array[2,1]));
>                                ^
> HINT:  No function matches the given name and argument types. You might
> need to add explicit type casts.
> LOCATION:  ParseFuncOrColumn, parse_func.c:629


tested on postgresql 14.
git.postgresql.org Git - postgresql.git/blob -
src/test/regress/sql/multirangetypes.sql
<https://git.postgresql.org/gitweb/?p=postgresql.git;a=blob;f=src/test/regress/sql/multirangetypes.sql;h=9be26f10d381f4af61a48f55606a80e49706b959;hb=6df7a9698bb036610c1e8c6d375e1be38cb26d5f>
line:590
to 600.
git.postgresql.org Git - postgresql.git/blob -
src/test/regress/expected/multirangetypes.out
<https://git.postgresql.org/gitweb/?p=postgresql.git;a=blob;f=src/test/regress/expected/multirangetypes.out;h=ac2eb84c3af90db38a14609749a5607653d0b26e;hb=7ae1619bc5b1794938c7387a766b8cae34e38d8a#l2849>
line
3200 to line 3210

I search log: git.postgresql.org Git - postgresql.git/log
<https://git.postgresql.org/gitweb/?p=postgresql.git;a=log;h=6df7a9698bb036610c1e8c6d375e1be38cb26d5f>
there
is no mention of  arrayrange. So this feature is  available, but now seems
not working?
db fiddle: Postgres 14 | db<>fiddle (dbfiddle.uk)
<https://dbfiddle.uk/?rdbms=postgres_14&fiddle=b3cb2a726ff5cedbf8aa05e11c5287e4>

Reply via email to