Changes between Version 4 and Version 5 of Stored Functions and Procedures

Timestamp:

05/13/26 17:49:42 (13 days ago)

Author:

193284

Comment:

--

Stored Functions and Procedures

@@ -61 +61 @@
 $$ LANGUAGE plpgsql;
 </pre>
+
+This function does not only compare equal dates. It compares complete timestamp intervals using:
+
+{{{
+#!sql
+(new_start < existing_end) AND (new_end > existing_start)
+}}}
+
+This condition detects all possible overlap cases:
+* the new interval starts inside an existing interval
+* the new interval ends inside an existing interval
+* the new interval completely contains an existing interval
+* the existing interval completely contains the new interval
+* both intervals are exactly the same
+* intervals that only touch at the boundary are not treated as overlapping
 
 == 3. is_photographer_available() ==