SQL Maestro Group / Products / PostgreSQL / PostgreSQL Maestro / Documentation

PostgreSQL Maestro online Help

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 types are useful because they represent many element values in a single range value, and because concepts such as overlapping ranges can be expressed clearly. The use of time and date ranges for scheduling purposes is the clearest example; but price ranges, measurement ranges from an instrument, and so forth can also be useful.

New range types are created within Create Range Type Wizard. In order to run the wizard you should either

•	select the Object \| Create Database Object... main menu item;

•	select the Range Type icon in the Create Database Object dialog

•	select the Range Types list or any object from that list in the explorer tree;

•	select the Create New Range Type... item from the popup menu

To create a new range type with the same properties as one of the existing one has:

•	select the Object \| Duplicate Database Object... main menu item;

•	follow the instructions of Duplicate Object Wizard.

Range data types can be edited within Range Type Editor. In order to run the editor you should either

•	select the range type for editing in the explorer tree (type the first letters of the type name for quick search);

•	select the Edit Range Type... item from the popup menu

To drop a range data type:

•	select the type to drop in the explorer tree;

•	select the Drop Range Type item from the popup menu

and confirm dropping in the dialog window.

PostgreSQL Maestro online Help

Range Types