Changes between Version 3 and Version 4 of Trigger Functions
- Timestamp:
- 05/12/26 02:27:57 (2 weeks ago)
Legend:
- Unmodified
- Added
- Removed
- Modified
-
Trigger Functions
v3 v4 15 15 === SQL Code === 16 16 17 {{collapse(View SQL Code) 18 <syntaxhighlight lang="sql"> 17 <pre> 19 18 CREATE OR REPLACE FUNCTION check_venue_booking_overlap() 20 19 RETURNS TRIGGER AS $$ … … 42 41 FOR EACH ROW 43 42 EXECUTE FUNCTION check_venue_booking_overlap(); 44 </syntaxhighlight> 45 }} 43 </pre> 46 44 47 45 == 2. Photographer Booking Conflict Prevention == … … 53 51 === SQL Code === 54 52 55 {{collapse(View SQL Code) 56 <syntaxhighlight lang="sql"> 53 <pre> 57 54 CREATE OR REPLACE FUNCTION check_photographer_booking_overlap() 58 55 RETURNS TRIGGER AS $$ … … 80 77 FOR EACH ROW 81 78 EXECUTE FUNCTION check_photographer_booking_overlap(); 82 </syntaxhighlight> 83 }} 79 </pre> 84 80 85 81 == 3. Band Booking Conflict Prevention == … … 91 87 === SQL Code === 92 88 93 {{collapse(View SQL Code) 94 <syntaxhighlight lang="sql"> 89 <pre> 95 90 CREATE OR REPLACE FUNCTION check_band_booking_overlap() 96 91 RETURNS TRIGGER AS $$ … … 118 113 FOR EACH ROW 119 114 EXECUTE FUNCTION check_band_booking_overlap(); 120 </syntaxhighlight> 121 }} 115 </pre> 122 116 123 117 == 4. Attendance Consistency Validation == … … 129 123 === SQL Code === 130 124 131 {{collapse(View SQL Code) 132 <syntaxhighlight lang="sql"> 125 <pre> 133 126 CREATE OR REPLACE FUNCTION validate_attendance_consistency() 134 127 RETURNS TRIGGER AS $$ … … 155 148 FOR EACH ROW 156 149 EXECUTE FUNCTION validate_attendance_consistency(); 157 </syntaxhighlight> 158 }} 150 </pre>
