Range

Inclusive/Exclusive Bounds

  • [] is used to represent inclusive values
  • () is used to represent exclusive values
  • ex. SELECT '[3,7)'::int4range is a range that includes 3, but discludes 7

Omitting Upper/Lower Bounds

We can omit upper bounds with [7,] We can omit lower bounder with [,7]