Changes between Version 37 and Version 38 of DatabaseProgramming

Timestamp:

06/16/26 08:23:36 (20 hours ago)

Author:

231028

Comment:

--

DatabaseProgramming

@@ -357 +357 @@
     begin
         if not exists(
+            select *
+            from Ride r
+            where r.id=id_ride
+        )then
+            raise exception 'Ride does not exist.';
+        end if;
+        if not exists(
             select 1
             from Ride r
@@ -380 +387 @@
 as $$
     begin
+        if not exists(
+            select *
+            from Ride r
+            where r.id=id_ride
+        )then
+            raise exception 'Ride does not exist.';
+        end if;
         if not exists(
             select 1
@@ -404 +418 @@
 as $$
     begin
+        if not exists(
+            select *
+            from Ride r
+            where r.id=id_ride
+        )then
+            raise exception 'Ride does not exist.';
+        end if;
         if not exists(
             select 1