between predicate

Tests whether expr1 is greater or equal than expr2 and less than or equal to expr3.

Syntax 

expr1 [not] between expr2 and expr3

Arguments

  • expr1: An expression of any comparable type.

  • expr2: An expression that shares a least common type with all other arguments.

  • expr3: An expression that shares a least common type with all other arguments.

Returns

The results is a BOOLEAN.

If not is specified the function is a synonym for expr1 < expr2 or expr1 > expr3.

Without not the function is a synonym for expr1 >= expr2 and expr1 <= expr3.

Examples 

> SELECT 4 between 3 and 5;
 true

> SELECT 4 not between 3 and 5;
 false

> SELECT 4 not between NULL and 5;
 NULL