Index: openacs-4/packages/acs-events/sql/postgresql/timespan-create.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/acs-events/sql/postgresql/timespan-create.sql,v diff -u -r1.9 -r1.9.2.1 --- openacs-4/packages/acs-events/sql/postgresql/timespan-create.sql 18 Apr 2018 09:09:12 -0000 1.9 +++ openacs-4/packages/acs-events/sql/postgresql/timespan-create.sql 29 May 2023 09:39:06 -0000 1.9.2.1 @@ -316,8 +316,6 @@ --- added -select define_function_args('time_interval__overlaps_p','interval_id,start_date;null,end_date;null'); -- -- procedure time_interval__overlaps_p/3 @@ -333,6 +331,7 @@ -- -- @return true if the interval bounded by start_date through end_date, false otherwise. -- + CREATE OR REPLACE FUNCTION time_interval__overlaps_p( overlaps_p__interval_id integer, overlaps_p__start_date timestamptz, -- default null, @@ -360,8 +359,6 @@ $$ LANGUAGE plpgsql; - - -- -- procedure time_interval__overlaps_p/4 -- @@ -377,6 +374,9 @@ -- -- @return true if intervals overlap, otherwise false. -- + +select define_function_args('time_interval__overlaps_p','start_1,end_1,start_2,end_2'); + CREATE OR REPLACE FUNCTION time_interval__overlaps_p( overlaps_p__start_1 timestamptz, overlaps_p__end_1 timestamptz,