range_tools 0.1.2

This Release
range_tools 0.1.2
Date
Status
Stable
Latest Unstable
range_tools 0.1.0 —
Other Releases
Abstract
Tools for use with range types
Description
Various tools that make it easier to work with range types
Released By
decibel
License
MIT
Resources
Special Files

Extensions

range_tools 0.1.2
Tools for use with range types

README

Current Status

PGXN version Build Status

Existing function APIs should be stable. Let me know what other tools you could use!

Supported Versions

Works on Postgres 9.5 and above. Currently restricted because 9.5 is the version that introduced the timestamp creation functions.

Functions

range_from_array()

These functions will create a range type that spans all the values in the input array.

When the extention is installed, it will create types for all the range types that are in pg_catalog. You can create additional range_from_array() functions by calling _range_from_array__create(range_type).

Views

range_types

This view denormalizes most of the information about all of the range types in the system. It is based on the pg_range catalog table.