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