Re: [Davical-general] Overlap calculation

[Ben H. <0x6...@gm...>]

On Mon, Jan 22, 2018 at 10:33 PM, Ben Hood <0x6...@gm...> wrote:
> IF repeatrule IS NULL THEN
>   RETURN (dtstart <= maxdate AND base_date >= mindate);
> END IF;

I was wondering if it would make more sense to patch this branch like so:

IF repeatrule IS NULL THEN
  event_range := tstzrange(dtstart, dtend);
  constraint_range := tstzrange(in_mindate, in_maxdate);
  IF isempty(constraint_range) THEN
    RETURN event_range @> mindate;
  ELSE
    RETURN event_range @> constraint_range;
  END IF;
END IF;