[BUGS] BUG #14854: daterange[] is an anyarray or anyrange?

The following bug has been logged on the website:

Bug reference:      14854
Logged by:          Balazs Szilfai
Email address:      balazs@obiserver.hu
PostgreSQL version: 9.6.5
Operating system:   Debian Linux
Description:

I can't create function with param to accept a pseudo-type to daterange and
daterange[] (array of daterange).

I tried:

CREATE FUNCTION range_overlap_array_any(anyrange, anyarray) RETURNS boolean
AS $$SELECT false;$$ LANGUAGE sql IMMUTABLE STRICT;

CREATE FUNCTION range_overlap_array_any(anyrange, anyrange) RETURNS boolean
AS $$SELECT false;$$ LANGUAGE sql IMMUTABLE STRICT;

My queries and the error messages:

SELECT range_overlap_array_any(daterange('2017-01-01', '2017-04-01'),
array[daterange('2016-12-10', '2016-12-11')]);

ERROR:  function range_overlap_array_any(daterange, daterange[]) does not
exist


SELECT range_overlap_array_any(daterange('2017-01-01', '2017-04-01'),
array['x'::text]);

ERROR:  function range_overlap_array_any(daterange, text[]) does not exist

What's the mistake? Or did I break something?


--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs