Changes between Version 20 and Version 21 of DatabaseProgramming

Timestamp:

06/15/26 11:53:47 (2 days ago)

Author:

231072

Comment:

--

DatabaseProgramming

@@ -653 +653 @@
 BEGIN
 
-    -- земи тековна залиха
+    
     SELECT quantity
     INTO v_stock
@@ -659 +659 @@
     WHERE product_id = NEW.product_id;
 
-    -- ако нема продукт
+    
     IF NOT FOUND THEN
         RAISE EXCEPTION 'Product % does not exist', NEW.product_id;
     END IF;
 
-    -- ако нема доволно залиха
+    
     IF v_stock < NEW.quantity THEN
         RAISE EXCEPTION