Databases Reference
In-Depth Information
Combined schedule
The repeat interval can also be combined, and it can be seen as a set of points in time
that can be intersected with other points in time, it can be included, excluded, or
intersected. The repeated schedules are included only once in the resulting schedule.
combined_schedule = schedule_list [";" include_clause] [";" exclude_
clause] [";" intersect_clauseintersect_clause]
Combined Schedule INCLUDE
Combined Schedule EXCLUDE
Schedule
List A
Schedule
List B
Schedule
List A
Schedule
List B
Combine Schedule INTERSECT
Repeated schedules are included only once
Schedule
List A
Schedule
List B
As previously shown on the diagram there are three ways to define a combined
schedule. They are the
include
,
exclude
and
intersect
clauses.
Include
: The
include
clause merges the resulting schedules from two or more
named schedule lists. The repeated schedules are included only once. The
include
operation is equivalent to the Union set operator.
Exclude
: This excludes the values in common with the schedule list A. The
exclude
clause is equivalent to the Minus set operator.
Intersect
: The
intersect
clause is equivalent to the
intersect
set operator. This
specifies an intersection between the calendaring expression results and the set of
timestamps defined by one or more named schedules. Only the timestamps that
appear both in the calendaring expression and in one of the named schedules are
included in the resulting set of timestamps.
Search WWH ::
Custom Search