 AND   EXTRACT( MONTH FROM calendar_date) = 3
 ; 
 
-
--- Good Friday
-UPDATE dim_calendar
-SET hol_ca_nl = TRUE
-WHERE calc_western_good_fri = TRUE
-; 
-
-
--- Monday after Easter Day	Easter Monday	Lundi de Pâques
-UPDATE dim_calendar
-SET hol_ca_nl = TRUE
-WHERE calc_western_easter_mon = TRUE
-; 
+-- 
+-- -- Good Friday
+-- UPDATE dim_calendar
+-- SET hol_ca_nl = TRUE
+-- WHERE calc_western_good_fri = TRUE
+-- ; 
+-- 
+-- 
+-- -- Monday after Easter Day	Easter Monday	Lundi de Pâques
+-- UPDATE dim_calendar
+-- SET hol_ca_nl = TRUE
+-- WHERE calc_western_easter_mon = TRUE
+-- ; 
 
 
 -- April 23	Saint George's Day	Jour de St. George

; 


-- December 26	Boxing Day	Lendemain de Noël
UPDATE dim_calendar
SET hol_ca_nl = TRUE
WHERE EXTRACT( DAY   FROM calendar_date) = 26
AND   EXTRACT( MONTH FROM calendar_date) = 12
; 

COMMIT;

; 


-- -- Monday on or before May 24	Victoria Day	Fête de la Reine
-- WITH cte AS (
--     SELECT EXTRACT(YEAR FROM dc2.calendar_date) AS yr,
--            MAX(calendar_date) AS mon_may_24
--            FROM dim_calendar AS dc2
--            WHERE EXTRACT(MONTH FROM calendar_date) = 5
--            AND   EXTRACT(DAY FROM celndar_date) <= 24
--            AND EXTRACT( DOW FROM calendar_date) = 1
--            GROUP BY EXTRACT(YEAR FROM dc2.calendar_date)
-- )
-- UPDATE dim_calendar
-- SET hol_ca_nl = TRUE
-- FROM cte
-- WHERE dim_calendar.calendar_date = cte.mon_may_24
-- ;
-- 
--June 24	Discovery Day / National Holiday	Journée découverte / Fête nationale du Québec / Saint-Jean-Baptiste
UPDATE dim_calendar
SET hol_ca_nl = TRUE
WHERE EXTRACT( DAY   FROM calendar_date) = 24
AND   EXTRACT( MONTH FROM calendar_date) = 6
; 

-- July 12	Orangemen's Day	Fête des orangistes
UPDATE dim_calendar
SET hol_ca_nl = TRUE
