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?
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 |