Changes between Version 35 and Version 36 of DatabaseProgramming

Timestamp:

06/16/26 02:31:37 (26 hours ago)

Author:

231119

Comment:

--

DatabaseProgramming

@@ -199 +199 @@
     where o.id = v_offer_id;
 
-    v_vehicle_vin := (select vin_vehicle from driver_vehicle where id_driver = v_driver_id);
+    v_vehicle_vin := (select vin_vehicle from driver_vehicle where id_driver = v_driver_id and (time_to is null or time_to > now()));
 
     insert into ride(start_time,