Usage Notes
-
ASYMMETRIC
is used by default if neitherASYMMETRIC
norSYMMETRIC
is specified. -
If
SYMMETRIC
is specified, the order of the specified limits will not matter. -
a BETWEEN b AND c
anda BETWEEN ASYMMETRIC b AND c
are both equivalent tob <= 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 forBETWEEN SYMMETRIC
. For example,1 BETWEEN SYMMETRIC 0 AND 3
and1 BETWEEN SYMMETRIC 3 AND 0
are both true. -
a NOT BETWEEN b AND c
anda NOT BETWEEN ASYMMETRIC b AND c
are both equivalent toNOT (a BETWEEN ASYMMETRIC b AND c)
. -
a NOT BETWEEN SYMMETRIC b AND c
is equivalent toNOT (a BETWEEN SYMMETRIC b AND c)
.