Changes between Version 4 and Version 5 of функции,процедури,тригери
- Timestamp:
- 06/14/26 19:08:19 (4 months ago)
Legend:
- Unmodified
- Added
- Removed
- Modified
-
функции,процедури,тригери
v4 v5 58 58 END; 59 59 $$ LANGUAGE plpgsql; 60 60 61 get_available_seats 61 62 … … 77 78 END; 78 79 $$ LANGUAGE plpgsql; 80 79 81 get_movie_avg_rating 80 82 … … 159 161 $$; 160 162 Процедури 163 161 164 generate_tickets_for_screening 162 165 … … 242 245 END; 243 246 $$; 247 244 248 purchase_ticket_with_products 245 249 … … 305 309 END; 306 310 $$; 311 307 312 add_movie_review 308 313 … … 329 334 FOR EACH ROW 330 335 EXECUTE FUNCTION check_seat_availability(); 336 331 337 trg_check_seat_availability 332 338 … … 350 356 FOR EACH ROW 351 357 EXECUTE FUNCTION notify_on_reservation(); 358 352 359 trg_notify_on_reservation 353 360 … … 373 380 FOR EACH ROW 374 381 EXECUTE FUNCTION complete_past_reservations(); 382 375 383 trg_complete_past_reservations 376 384
