PostgreSQL data type for simple trapezoidal fuzzy time intervals and fuzzy temporal relations.
pgext.cloud · Source code · Documentation · License text · Control file
| Package | pgsfti |
|---|---|
| Version | 1.0 |
| Repository | Unspecified |
| Extension type | Standard |
| Requires CREATE EXTENSION | Yes |
| Requires preload | No |
| Trusted | No |
| Relocatable | Yes |
| Stars | 4 |
| Latest commit | 2023-06-16 |
| Catalogue updated | 2026-08-30 |
| geohistorical_objects | Geohistorical objects support |
| temporal | C extension providing a PERIOD type over timestamp-with-time-zone values, temporal relation operators and functions, plus GiST indexing support. |
| time_for_keys | C and PL/pgSQL helpers that enforce temporal foreign keys between valid-time tables with constraint triggers. |
| range_agg | range_agg: merge adjacent or overlapping PostgreSQL range values |
| lostgis | LostGIS spatial helper functions and types |
| sql_saga_native | Rust/pgrx companion library that accelerates sql_saga temporal_merge planning and executor introspection. |
| pg_timelord | Proof-of-concept time-travel queries using commit timestamps and a custom MVCC snapshot. |
| pgtime | Temporal 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. |
| timeql | Native temporal history tracking and point-in-time queries using PostgreSQL range types and GiST indexes. |