Changes between Version 24 and Version 25 of DatabaseProgramming

Timestamp:

05/13/26 16:04:37 (13 days ago)

Author:

231027

Comment:

--

DatabaseProgramming

@@ -118 +118 @@
 DECLARE
     v_happening_id BIGINT;
-    v_seat_record RECORD;
 BEGIN
     INSERT INTO "Event_Happening" (event_id, event_time, venue_id, duration)
@@ -124 +123 @@
     RETURNING event_happening_id INTO v_happening_id;
 
-    FOR v_seat_record IN
-        SELECT seat_id FROM "Seat" s
-        JOIN "Section" sec ON s.section_id = sec.section_id
-        WHERE sec.venue_id = p_venue_id
-    LOOP
-        INSERT INTO "Ticket" (ticket_type, base_price, is_available, event_happening_id, seat_id)
-        VALUES ('Standard', p_base_price, TRUE, v_happening_id, v_seat_record.seat_id);
-    END LOOP;
-    
+    INSERT INTO "Ticket" (ticket_type, base_price, is_available, event_happening_id, seat_id)
+    SELECT 
+        'Standard', 
+        p_base_price, 
+        TRUE, 
+        v_happening_id, 
+        s.seat_id
+    FROM "Seat" s
+    JOIN "Section" sec ON s.section_id = sec.section_id
+    WHERE sec.venue_id = p_venue_id;
+
     RAISE NOTICE 'Event scheduled and tickets generated.';
 END;