Postgres Pro
Downloads
Home   >   mailing lists

Re: multirange of arrays not working on postgresql 14 - Mailing list pgsql-hackers

From David G. Johnston
Subject Re: multirange of arrays not working on postgresql 14
Date
Msg-id CAKFQuwZwkfbFj3xA3X2wEH9wNpoRuR0MgO9sD=a9j9BN-7F1Pg@mail.gmail.com
Whole thread Raw
In response to multirange of arrays not working on postgresql 14  (Jian He <hejian.mark@gmail.com>)
List pgsql-hackers
Tree view
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.

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?


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 by date:

Previous
From: Bharath Rupireddy
Date:
Subject: Re: Throttling WAL inserts when the standby falls behind more than the configured replica_lag_in_bytes
Next
From: Bharath Rupireddy
Date:
Subject: Re: [Patch] ALTER SYSTEM READ ONLY