aonestar
.public
Tables
(current)
Columns
Constraints
Relationships
Orphan Tables
Anomalies
Routines
fn_is_holiday
Parameters
Name
Type
Mode
p_date
date
IN
Definition
SELECT EXISTS ( SELECT 1 FROM public.calendar_event e JOIN public.calendar c ON c.id = e.calendar_id WHERE c.enabled AND e.enabled AND c.is_public_holiday AND p_date BETWEEN e.start_date AND coalesce(e.end_date, e.start_date) )