edtf_postgres

Overview

Trusted extension; upstream Cargo requests pgrx 0.19.1 and the locked build uses 0.19.2.

Version

Build

You can build the RPM / DEB packages for edtf_postgres using pig build:

pig build pkg edtf_postgres         # build RPM / DEB packages

Install

You can install edtf_postgres directly. First, make sure the PGDG and PIGSTY repositories are added and enabled:

pig repo add pgsql -u          # Add repo and update cache

Install the extension using pig or apt/yum/dnf:

pig install edtf_postgres;          # Install for current active PG version

pig ext install -y edtf_postgres -v 18  # PG 18
pig ext install -y edtf_postgres -v 17  # PG 17
pig ext install -y edtf_postgres -v 16  # PG 16
pig ext install -y edtf_postgres -v 15  # PG 15
pig ext install -y edtf_postgres -v 14  # PG 14

dnf install -y edtf_postgres_18       # PG 18
dnf install -y edtf_postgres_17       # PG 17
dnf install -y edtf_postgres_16       # PG 16
dnf install -y edtf_postgres_15       # PG 15
dnf install -y edtf_postgres_14       # PG 14

apt install -y postgresql-18-edtf-postgres   # PG 18
apt install -y postgresql-17-edtf-postgres   # PG 17
apt install -y postgresql-16-edtf-postgres   # PG 16
apt install -y postgresql-15-edtf-postgres   # PG 15
apt install -y postgresql-14-edtf-postgres   # PG 14

Create Extension:

CREATE EXTENSION edtf_postgres;

Usage

Sources:

• Official extension README
• Extension control file
• pgrx manifest

edtf_postgres exposes Extended Date/Time Format validation, normalization, bounds, and temporal relations for ISO 8601-2:2019 Annex A strings.

Enablement

Release 1.2.3 publishes artifacts for PostgreSQL 14–18 on amd64 and arm64. Install the matching artifact, then run:

CREATE EXTENSION edtf_postgres;

The extension is relocatable and trusted, so a role with database CREATE privilege can install it. It does not require preloading.

Validation and Canonical Form

Use edtf_valid before accepting external text, edtf_level to inspect the supported EDTF level, and edtf_canonical to normalize equivalent forms.

SELECT edtf_valid('1985-04-12');
SELECT edtf_level('1985-04-12/..');
SELECT edtf_canonical('1985-04-12');

edtf_min and edtf_max return index-friendly date bounds. edtf_relation compares two expressions and returns a three-valued temporal relation.

SELECT edtf_min('1985-04'), edtf_max('1985-04');
SELECT edtf_relation('1985', '1986');

Data Modeling Boundary

The extension operates on text and derived dates; it does not replace application validation or introduce a stored EDTF base type. Preserve the original expression when uncertainty and qualifiers are significant, and index derived bounds only for the query semantics your application intends.