select open change scope Open full search

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

Extensions / Time series

bitemp_retrieval

Retrieval, coalescing, and join helpers for bitemporal tables created by pg_bitemporal.

pgext.cloud · Source code · Documentation · Control file

Overview

Packagebitemp_retrieval
Version0.0.1
RepositoryUnspecified
Extension typeStandard
Project statusActive
Requires CREATE EXTENSIONYes
Requires preloadNo
TrustedNo
RelocatableNo
Stars1
Latest commit2023-09-17
Catalogue updated2026-08-30

Related extensions

See also

time_for_keysC and PL/pgSQL helpers that enforce temporal foreign keys between valid-time tables with constraint triggers.
emajEnables fine-grained write logging and time travel on subsets of the database.
temporal_tablestemporal tables
temporalC extension providing a PERIOD type over timestamp-with-time-zone values, temporal relation operators and functions, plus GiST indexing support.
pgtimeTemporal tables extension for PostgreSQL. Automatically tracks Transaction Time (system time) on any table using range types and a high-performance C-based AFTER ROW trigger.
sql_sagaC and PL/pgSQL extension for valid-time temporal tables, temporal foreign keys, history-preserving views, and bulk temporal merge operations.
timetravelTencentDB for PostgreSQL provider extension named timetravel, available as version 1.0 on PostgreSQL 10 and 11.
temporal_rtreeExperimental temporal R-tree access method implemented as a PostgreSQL extension.