Обсуждение: multirange of arrays not working on postgresql 14
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 line:590 to 600.
git.postgresql.org Git - postgresql.git/blob - src/test/regress/expected/multirangetypes.out line 3200 to line 3210
I search log: git.postgresql.org Git - postgresql.git/log there is no mention of arrayrange. So this feature is available, but now seems not working?
db fiddle: Postgres 14 | db<>fiddle (dbfiddle.uk)
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:629tested on postgresql 14.git.postgresql.org Git - postgresql.git/blob - src/test/regress/sql/multirangetypes.sql line:590 to 600. git.postgresql.org Git - postgresql.git/blob - src/test/regress/expected/multirangetypes.out line 3200 to line 3210 I search log: git.postgresql.org Git - postgresql.git/log there is no mention of arrayrange. So this feature is available, but now seems not working?db fiddle: Postgres 14 | db<>fiddle (dbfiddle.uk)
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.