Changes between Version 7 and Version 8 of Stored Functions and Procedures

Timestamp:

05/18/26 22:30:29 (8 days ago)

Author:

193284

Comment:

--

Stored Functions and Procedures

@@ -102 +102 @@
           AND vb.status <> 'cancelled'
           AND (
-                (p_date + p_start) < (vb."date" + vb.end_time)
-            AND (p_date + p_end)   > (vb."date" + vb.start_time)
+
+                ((p_date + p_start) >= (vb."date" + vb.start_time)
+                 AND (p_date + p_start) < (vb."date" + vb.end_time))
+
+                OR
+
+                ((p_date + p_end) > (vb."date" + vb.start_time)
+                 AND (p_date + p_end) <= (vb."date" + vb.end_time))
+
+                OR
+
+                ((p_date + p_start) <= (vb."date" + vb.start_time)
+                 AND (p_date + p_end) >= (vb."date" + vb.end_time))
+
+                OR
+
+                ((p_date + p_start) >= (vb."date" + vb.start_time)
+                 AND (p_date + p_end) <= (vb."date" + vb.end_time))
           )
     );
 END;
 $$ LANGUAGE plpgsql;
-}}}
 
 == 3. is_photographer_available() ==
@@ -142 +157 @@
           AND pb.status <> 'cancelled'
           AND (
-                (p_date + p_start) < (pb."date" + pb.end_time)
-            AND (p_date + p_end)   > (pb."date" + pb.start_time)
+
+                ((p_date + p_start) >= (pb."date" + pb.start_time)
+                 AND (p_date + p_start) < (pb."date" + pb.end_time))
+
+                OR
+
+                ((p_date + p_end) > (pb."date" + pb.start_time)
+                 AND (p_date + p_end) <= (pb."date" + pb.end_time))
+
+                OR
+
+                ((p_date + p_start) <= (pb."date" + pb.start_time)
+                 AND (p_date + p_end) >= (pb."date" + pb.end_time))
+
+                OR
+
+                ((p_date + p_start) >= (pb."date" + pb.start_time)
+                 AND (p_date + p_end) <= (pb."date" + pb.end_time))
           )
     );
 END;
 $$ LANGUAGE plpgsql;
-}}}
 
 == 4. is_band_available() ==
@@ -182 +212 @@
           AND bb.status <> 'cancelled'
           AND (
-                (p_date + p_start) < (bb."date" + bb.end_time)
-            AND (p_date + p_end)   > (bb."date" + bb.start_time)
+
+                ((p_date + p_start) >= (bb."date" + bb.start_time)
+                 AND (p_date + p_start) < (bb."date" + bb.end_time))
+
+                OR
+
+                ((p_date + p_end) > (bb."date" + bb.start_time)
+                 AND (p_date + p_end) <= (bb."date" + bb.end_time))
+
+                OR
+
+                ((p_date + p_start) <= (bb."date" + bb.start_time)
+                 AND (p_date + p_end) >= (bb."date" + bb.end_time))
+
+                OR
+
+                ((p_date + p_start) >= (bb."date" + bb.start_time)
+                 AND (p_date + p_end) <= (bb."date" + bb.end_time))
           )
     );
 END;
 $$ LANGUAGE plpgsql;
-}}}
 
 == 5. generate_rsvp_summary() ==