This extension serves two purposes:
- Extend the capabilities of range functions, with an eye toward moving the most useful of those functions into the core.
- Facilitate back-porting of functions from newer versions of PostgreSQL.
For function documentation and examples, see the range_type_functions.md file.
Requirements: PostgreSQL 9.4 or greater.
In the directory where you downloaded range_type_functions, run
make install
Log into PostgreSQL.
CREATE EXTENSION range_type_functions;
or
CREATE EXTENSION range_type_functions SCHEMA my_schema;
All functions created have execute granted to public.
Run "make install" same as above to put the script files and libraries in place. Then run the following in PostgreSQL itself:
ALTER EXTENSION range_type_functions UPDATE TO '<latest version>';