Changes between Version 2 and Version 3 of Triggers
- Timestamp:
- 08/31/25 23:56:47 (43 hours ago)
Legend:
- Unmodified
- Added
- Removed
- Modified
-
Triggers
v2 v3 16 16 BEGIN 17 17 IF NEW.quantity IS NULL OR NEW.quantity < 0 THEN 18 RAISE EXCEPTION ' quantity must be non-negative';18 RAISE EXCEPTION 'Количината не смее да биде негативна'; 19 19 END IF; 20 20 NEW.last_changed := CURRENT_DATE; … … 115 115 BEGIN 116 116 IF NEW.medicine_id_1 = NEW.medicine_id_2 THEN 117 RAISE EXCEPTION ' medicine cannot interact with itself';117 RAISE EXCEPTION 'Лек не може да биде во интеракција сам со себе'; 118 118 END IF; 119 119