generate_date_series

This Release
generate_date_series 1.0.0
Date
Status
Stable
Abstract
generate_series() for date types
Description
a generate_series()-like function that takes date ranges and integer intervals (in number of days)
Released By
chuinker
License
The PostgreSQL License
Resources
Special Files
Tags

Extensions

generate_date_series 1.0.0
generate_series() for date types

Documentation

LICENSE
Copyright and License

README

generate_date_series

PGXN version

generate_date_series is an extension that provides a generate_series()-like function that takes date inputs and an integer interval (representing days).

USAGE

For function documentation and examples, see the generate_date_series.md file.

INSTALLATION

Requirements: PostgreSQL 9.2 or greater.

In the directory where you downloaded generate_date_series, run

bash make && make install

Log into PostgreSQL.

Run the following command:

sql CREATE EXTENSION generate_date_series;

To all any user to execute this new function, run the following grant:

sql GRANTE execute on generate_date_series(date,date,integer) to public;

UPGRADE

Run "make && make install" same as above to put the script files and libraries in place. Then run the following in PostgreSQL itself:

sql ALTER EXTENSION generate_date_series UPDATE TO '<latest version>';