Changes between Version 4 and Version 5 of функции,процедури,тригери


Ignore:
Timestamp:
06/14/26 19:08:19 (11 days ago)
Author:
231233
Comment:

--

Legend:

Unmodified
Added
Removed
Modified
  • функции,процедури,тригери

    v4 v5  
    5858END;
    5959$$ LANGUAGE plpgsql;
     60
    6061get_available_seats
    6162
     
    7778END;
    7879$$ LANGUAGE plpgsql;
     80
    7981get_movie_avg_rating
    8082
     
    159161$$;
    160162Процедури
     163
    161164generate_tickets_for_screening
    162165
     
    242245END;
    243246$$;
     247
    244248purchase_ticket_with_products
    245249
     
    305309END;
    306310$$;
     311
    307312add_movie_review
    308313
     
    329334FOR EACH ROW
    330335EXECUTE FUNCTION check_seat_availability();
     336
    331337trg_check_seat_availability
    332338
     
    350356FOR EACH ROW
    351357EXECUTE FUNCTION notify_on_reservation();
     358
    352359trg_notify_on_reservation
    353360
     
    373380FOR EACH ROW
    374381EXECUTE FUNCTION complete_past_reservations();
     382
    375383trg_complete_past_reservations
    376384