Changes between Version 3 and Version 4 of Procedures

Timestamp:

08/17/25 23:01:34 (44 hours ago)

Author:

221012

Comment:

--

Procedures

@@ -239 +239 @@
     )
     AND status != 'rented';
-    
+
     UPDATE domify.Listing
     SET status = 'available'
     WHERE available_from <= CURRENT_DATE 
       AND available_to >= CURRENT_DATE
-      AND status NOT IN ('rented', 'expired')
+      AND status != 'expired'
       AND NOT EXISTS (
           SELECT 1 
@@ -253 +253 @@
       );
 END;
+
 $$;
 }}}