--
-- timespan__overlaps_interval_p/2
--
create or replace function timespan__overlaps_interval_p(
  integer,
  integer
) returns bool as $$

declare
       overlaps_interval_p__timespan_id   alias for $1;
       overlaps_interval_p__interval_id   alias for $2; -- default null
       v_start_date		  timestamptz;
       v_end_date		  timestamptz;
begin
       select start_date, end_date
       into   v_start_date, v_end_date
       from   time_intervals
       where  interval_id = overlaps_interval_p__interval_id;
        
       return timespan__overlaps_p(
			overlaps_interval_p__timespan_id, 
			v_start_date, 
			v_end_date
			);

end;$$ language plpgsql;