Re: multirange of arrays not working on postgresql 14
| От | David G. Johnston |
|---|---|
| Тема | Re: multirange of arrays not working on postgresql 14 |
| Дата | |
| Msg-id | CAKFQuwZwkfbFj3xA3X2wEH9wNpoRuR0MgO9sD=a9j9BN-7F1Pg@mail.gmail.com обсуждение исходный текст |
| Ответ на | multirange of arrays not working on postgresql 14 (Jian He <hejian.mark@gmail.com>) |
| Список | pgsql-hackers |
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.
В списке pgsql-hackers по дате отправления: