Changes between Version 28 and Version 29 of DatabaseProgramming


Ignore:
Timestamp:
06/16/26 01:33:28 (10 hours ago)
Author:
231093
Comment:

--

Legend:

Unmodified
Added
Removed
Modified
  • DatabaseProgramming

    v28 v29  
    470470    end if;
    471471
    472     if (select company_id from employmenthistory where employee_user_id = dispatcher_user_id and end_date is null) !=
    473        (select company_id from employmenthistory where employee_user_id = driver_user_id and end_date is null) then
    474         raise exception 'Dispatcher and driver company mismatch';
    475     end if;
    476 
    477472    insert into offer(status, created_at, request_id, dispatcher_user_id, driver_user_id, price, currency_catalog_id,
    478473                      eta, customer_user_id)