Online Documentation for SQL Manager for PostgreSQL

Range Types


A Type is internally represented as an existing type, but is considered to be a separate data type.

 

Range types are data types representing a range of values of some element type (called the range's subtype). For instance, ranges of timestamp might be used to represent the ranges of time that a meeting room is reserved. In this case the data type is tsrange (short for "timestamp range"), and timestamp is the subtype. The subtype must have a total order so that it is well-defined whether element values are within, before, or after a range of values.

 

Range Type Editor allows you to define range type properties. It opens automatically when you create a new range type and is available on editing an existing one.