multirange of arrays not working on postgresql 14

On Friday, April 22, 2022, Jian He <hejian.mark@gmail.com> wrote:

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&gt; 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&gt; 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&gt; 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&amp;fiddle=b3cb2a726ff5cedbf8aa05e11c5287e4&gt;

The regression tests you link to (check out rangetypes.sql) define those
types using the user extensible type system PostgreSQL offers. As
evidenced by their absence from the documentation, those types are not part
of the core system.

David J.