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