Element of an array in a daterange?
I've got an array of dates, and I want to find out if any of the elements in the array appear within a given daterange.


Depending on the query, you can use


row aggregation with bool_or mentioned by joanolo in his answer.
or, you can use ANY with the contains operator @&gt;

SELECT daterange('2017-01-01', '2017-01-31', '[]')  @&gt; 
  ANY(ARRAY['2017-01-01'::date, '2017-02-03'::date]);

SELECT daterange('2017-01-01', '2017-01-31', '[]')  @&gt; 
  ANY(ARRAY['2016-01-02'::date, '2016-01-09'::date]);