Changes between Version 12 and Version 13 of DatabaseProgramming

Timestamp:

05/01/26 02:09:58 (37 hours ago)

Author:

231027

Comment:

--

DatabaseProgramming

@@ -286 +286 @@
 
 }}}
+
+== Тестирање на `func_period_val`, `trg_period_check`
+
+{{{
+
+-- get the time of an event happening
+SELECT event_time FROM "Event_Happening" WHERE event_happening_id = 1;  -- 2022-04-29 03:46:32.296118
+
+-- try to add an event period that is after the event happening
+INSERT INTO "Event_Period" (event_happening_id, start_date, end_date, price_change_percent, increase_decrease)
+VALUES (1, '2026-05-10', '2026-05-21', 10, TRUE);
+
+}}}