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

From: balazs(at)obiserver(dot)hu
To: pgsql-bugs(at)postgresql(dot)org
Cc: balazs(at)obiserver(dot)hu
Subject: BUG #14854: daterange[] is an anyarray or anyrange?
Date: 2017-10-13 19:45:21
Message-ID: 20171013194521.8203.22579@wrigleys.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

The following bug has been logged on the website:

Bug reference: 14854
Logged by: Balazs Szilfai
Email address: balazs(at)obiserver(dot)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?

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message David G. Johnston 2017-10-13 20:24:36 Re: BUG #14854: daterange[] is an anyarray or anyrange?
Previous Message John R Pierce 2017-10-13 19:03:57 Re: BUG #14851: Systemd kills long-running recovery