semver

pg_semver : Semantic version data type

Overview

Packages

Source

pig build pkg pg_semver;		# build rpm/deb

Install

Make sure PGDG repo available:

pig repo add pgdg -u    # add pgdg repo and update cache

Install this extension with pig:

pig install pg_semver;		# install via package name, for the active PG version
pig install semver;		# install by extension name, for the current active PG version

pig install semver -v 18;   # install for PG 18
pig install semver -v 17;   # install for PG 17
pig install semver -v 16;   # install for PG 16
pig install semver -v 15;   # install for PG 15
pig install semver -v 14;   # install for PG 14

Create this extension with:

CREATE EXTENSION semver;

Usage

Sources:

• doc/semver.md
• Changes
• semver.control
• sql/semver–0.41.0–0.42.0.sql

semver provides a Semantic Versioning 2.0.0 data type, comparison operators and the semverrange range type. Version 0.42.0 changes hashing: after upgrading, rebuild every hash index on semver values.

Core Workflow

CREATE EXTENSION semver;
SELECT '1.2.0'::semver > '1.2.0-b1'::semver;
SELECT '1.2.0'::semver = '1.2.0+build1'::semver;
SELECT to_semver('1.0'), is_semver('1.2.0');
SELECT get_semver_major('4.2.0'::semver);
SELECT '1.0.5'::semver <@ '[1.0.0,2.0.0)'::semverrange;

Operational Boundaries

semver(text) and casts from text require valid semantic versions; to_semver(text) performs more permissive conversion, and is_semver(text) checks validity. get_semver_major, get_semver_minor and get_semver_patch return integer components; get_semver_prerelease returns the prerelease text. Casts also accept numeric, real, double precision, integer, bigint and smallint. Version 0.42.0 rejects Infinity and NaN instead of producing malformed versions.

The comparison operators =, <>, <, <=, > and >=, plus MIN(semver) and MAX(semver), use semantic ordering. A prerelease sorts before its final release; build metadata does not affect precedence. Btree and hash indexes are available. semverrange supports standard range operations.

Install this native, untrusted extension with administrator privileges. After installing 0.42.0, run ALTER EXTENSION semver UPDATE and use REINDEX on every existing hash index containing semver keys. The hash change is not repaired by updating the extension’s SQL definitions alone. The release also fixes ordering of alphanumeric prerelease identifiers beginning with a digit and validation of strings with multiple plus signs. When upgrading from old releases, inspect the upstream compatibility notes for previously accepted invalid values.