Usage Notes
-
ASYMMETRIC is used by default if neither ASYMMETRIC nor SYMMETRIC is specified.
-
If SYMMETRIC is specified, the order of the specified limits will not matter.
-
a BETWEEN b AND c and a BETWEEN ASYMMETRIC b AND c are both equivalent to b <= a AND a <= c.
-
a BETWEEN SYMMETRIC b AND c is equivalent to (a BETWEEN ASYMMETRIC b AND c) OR (a BETWEEN ASYMMETRIC c AND b). This means that the order of the specified limits does not matter for BETWEEN SYMMETRIC. For example, 1 BETWEEN SYMMETRIC 0 AND 3 and 1 BETWEEN SYMMETRIC 3 AND 0 are both true.
-
a NOT BETWEEN b AND c and a NOT BETWEEN ASYMMETRIC b AND c are both equivalent to NOT (a BETWEEN ASYMMETRIC b AND c).
-
a NOT BETWEEN SYMMETRIC b AND c is equivalent to NOT (a BETWEEN SYMMETRIC b AND c).