select open change scope Open full search

PG.CENTER connects PostgreSQL documentation, reference, and ecosystem knowledge. Maintained by Pigsty.

Extensions / Functions and aggregates

generate_date_series

generate_series()-style set-returning function for date ranges with integer day steps.

pgext.cloud · Source code · Documentation · License text · Control file · PGXN

Overview

Packagegenerate_date_series
Version1.0.0
PostgreSQL versions10 · 11 · 12 · 13 · 14 · 15 · 16 · 17 · 18
RepositoryUnspecified
Extension typeStandard
Requires CREATE EXTENSIONYes
Requires preloadNo
TrustedNo
RelocatableYes
Stars2
Latest commit2016-05-23
Latest release2016-05-23
Catalogue updated2026-08-30

Related extensions

See also

srfMinimal C example implementing an inclusive integer set-returning function.
unnest_ordinalityLegacy array unnest function that returns each element with its ordinal position.