Changes between Version 2 and Version 3 of Triggers


Ignore:
Timestamp:
08/31/25 23:56:47 (43 hours ago)
Author:
222004
Comment:

--

Legend:

Unmodified
Added
Removed
Modified
  • Triggers

    v2 v3  
    1616BEGIN
    1717  IF NEW.quantity IS NULL OR NEW.quantity < 0 THEN
    18     RAISE EXCEPTION 'quantity must be non-negative';
     18    RAISE EXCEPTION 'Количината не смее да биде негативна';
    1919  END IF;
    2020  NEW.last_changed := CURRENT_DATE;
     
    115115BEGIN
    116116  IF NEW.medicine_id_1 = NEW.medicine_id_2 THEN
    117     RAISE EXCEPTION 'medicine cannot interact with itself';
     117    RAISE EXCEPTION 'Лек не може да биде во интеракција сам со себе';
    118118  END IF;
    119119