Re: multirange of arrays not working on postgresql 14

On Friday, April 22, 2022, Jian He <hejian(dot)mark(at)gmail(dot)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> 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>
>
>
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.