semver

pg_semver : Semantic version data type

Overview

IDExtensionPackageVersionCategoryLicenseLanguage
3510
semver
pg_semver
0.41.0
TYPE
PostgreSQL
C
AttributeHas BinaryHas LibraryNeed LoadHas DDLRelocatableTrusted
--s-d-r
No
Yes
No
Yes
yes
no
Relationships
See Also
prefix
ltree
citext
unit
pgpdf
pglite_fusion
md5hash
asn1oid

Packages

TypeRepoVersionPG Major CompatibilityPackage PatternDependencies
EXT
PGDG
0.41.0
18
17
16
15
14
pg_semver-
RPM
PGDG
0.41.0
18
17
16
15
14
semver_$v-
DEB
PGDG
0.41.0
18
17
16
15
14
postgresql-$v-semver-
Linux / PGPG18PG17PG16PG15PG14
el8.x86_64
PIGSTY 0.41.0
PIGSTY 0.41.0
PIGSTY 0.41.0
PIGSTY 0.41.0
PIGSTY 0.41.0
el8.aarch64
PIGSTY 0.41.0
PIGSTY 0.41.0
PIGSTY 0.41.0
PIGSTY 0.41.0
PIGSTY 0.41.0
el9.x86_64
PIGSTY 0.41.0
PIGSTY 0.41.0
PIGSTY 0.41.0
PIGSTY 0.41.0
PIGSTY 0.41.0
el9.aarch64
PIGSTY 0.41.0
PIGSTY 0.41.0
PIGSTY 0.41.0
PIGSTY 0.41.0
PIGSTY 0.41.0
el10.x86_64
PIGSTY 0.41.0
PIGSTY 0.41.0
PIGSTY 0.41.0
PIGSTY 0.41.0
PIGSTY 0.41.0
el10.aarch64
PIGSTY 0.41.0
PIGSTY 0.41.0
PIGSTY 0.41.0
PIGSTY 0.41.0
PIGSTY 0.41.0
d12.x86_64
PGDG 0.41.0
PGDG 0.41.0
PGDG 0.41.0
PGDG 0.41.0
PGDG 0.41.0
d12.aarch64
PGDG 0.41.0
PGDG 0.41.0
PGDG 0.41.0
PGDG 0.41.0
PGDG 0.41.0
d13.x86_64
PGDG 0.41.0
PGDG 0.41.0
PGDG 0.41.0
PGDG 0.41.0
PGDG 0.41.0
d13.aarch64
PGDG 0.41.0
PGDG 0.41.0
PGDG 0.41.0
PGDG 0.41.0
PGDG 0.41.0
u22.x86_64
PGDG 0.41.0
PGDG 0.41.0
PGDG 0.41.0
PGDG 0.41.0
PGDG 0.41.0
u22.aarch64
PGDG 0.41.0
PGDG 0.41.0
PGDG 0.41.0
PGDG 0.41.0
PGDG 0.41.0
u24.x86_64
PGDG 0.41.0
PGDG 0.41.0
PGDG 0.41.0
PGDG 0.41.0
PGDG 0.41.0
u24.aarch64
PGDG 0.41.0
PGDG 0.41.0
PGDG 0.41.0
PGDG 0.41.0
PGDG 0.41.0
PackageVersionOSORGSIZEFile URL
semver_180.41.0el8.x86_64pigsty27.5 KiBsemver_18-0.41.0-1PIGSTY.el8.x86_64.rpm
semver_180.41.0el8.x86_64pgdg28.4 KiBsemver_18-0.41.0-1PGDG.rhel8.10.x86_64.rpm
semver_180.40.0el8.x86_64pgdg27.9 KiBsemver_18-0.40.0-1PGDG.rhel8.x86_64.rpm
semver_180.41.0el8.aarch64pigsty27.2 KiBsemver_18-0.41.0-1PIGSTY.el8.aarch64.rpm
semver_180.41.0el8.aarch64pgdg28.0 KiBsemver_18-0.41.0-1PGDG.rhel8.10.aarch64.rpm
semver_180.40.0el8.aarch64pgdg27.5 KiBsemver_18-0.40.0-1PGDG.rhel8.aarch64.rpm
semver_180.41.0el9.x86_64pigsty26.9 KiBsemver_18-0.41.0-1PIGSTY.el9.x86_64.rpm
semver_180.41.0el9.x86_64pgdg27.2 KiBsemver_18-0.41.0-1PGDG.rhel9.7.x86_64.rpm
semver_180.40.0el9.x86_64pgdg26.9 KiBsemver_18-0.40.0-1PGDG.rhel9.x86_64.rpm
semver_180.41.0el9.aarch64pigsty26.7 KiBsemver_18-0.41.0-1PIGSTY.el9.aarch64.rpm
semver_180.41.0el9.aarch64pgdg26.8 KiBsemver_18-0.41.0-1PGDG.rhel9.7.aarch64.rpm
semver_180.40.0el9.aarch64pgdg26.5 KiBsemver_18-0.40.0-1PGDG.rhel9.aarch64.rpm
semver_180.41.0el10.x86_64pigsty27.0 KiBsemver_18-0.41.0-1PIGSTY.el10.x86_64.rpm
semver_180.41.0el10.x86_64pgdg27.3 KiBsemver_18-0.41.0-1PGDG.rhel10.1.x86_64.rpm
semver_180.40.0el10.x86_64pgdg27.4 KiBsemver_18-0.40.0-1PGDG.rhel10.x86_64.rpm
semver_180.41.0el10.aarch64pigsty27.2 KiBsemver_18-0.41.0-1PIGSTY.el10.aarch64.rpm
semver_180.41.0el10.aarch64pgdg27.3 KiBsemver_18-0.41.0-1PGDG.rhel10.1.aarch64.rpm
semver_180.40.0el10.aarch64pgdg27.4 KiBsemver_18-0.40.0-1PGDG.rhel10.aarch64.rpm
postgresql-18-semver0.41.0d12.x86_64pgdg39.1 KiBpostgresql-18-semver_0.41.0-1.pgdg12+1_amd64.deb
postgresql-18-semver0.41.0d12.aarch64pgdg38.5 KiBpostgresql-18-semver_0.41.0-1.pgdg12+1_arm64.deb
postgresql-18-semver0.41.0d13.x86_64pgdg38.6 KiBpostgresql-18-semver_0.41.0-1.pgdg13+1_amd64.deb
postgresql-18-semver0.41.0d13.aarch64pgdg38.8 KiBpostgresql-18-semver_0.41.0-1.pgdg13+1_arm64.deb
postgresql-18-semver0.41.0u22.x86_64pgdg38.7 KiBpostgresql-18-semver_0.41.0-1.pgdg22.04+1_amd64.deb
postgresql-18-semver0.41.0u22.aarch64pgdg38.2 KiBpostgresql-18-semver_0.41.0-1.pgdg22.04+1_arm64.deb
postgresql-18-semver0.41.0u24.x86_64pgdg38.7 KiBpostgresql-18-semver_0.41.0-1.pgdg24.04+1_amd64.deb
postgresql-18-semver0.41.0u24.aarch64pgdg38.6 KiBpostgresql-18-semver_0.41.0-1.pgdg24.04+1_arm64.deb
PackageVersionOSORGSIZEFile URL
semver_170.41.0el8.x86_64pigsty27.5 KiBsemver_17-0.41.0-1PIGSTY.el8.x86_64.rpm
semver_170.41.0el8.x86_64pgdg28.4 KiBsemver_17-0.41.0-1PGDG.rhel8.10.x86_64.rpm
semver_170.32.1el8.x86_64pgdg27.1 KiBsemver_17-0.32.1-1PGDG.rhel8.x86_64.rpm
semver_170.41.0el8.aarch64pigsty27.2 KiBsemver_17-0.41.0-1PIGSTY.el8.aarch64.rpm
semver_170.41.0el8.aarch64pgdg28.0 KiBsemver_17-0.41.0-1PGDG.rhel8.10.aarch64.rpm
semver_170.32.1el8.aarch64pgdg26.8 KiBsemver_17-0.32.1-1PGDG.rhel8.aarch64.rpm
semver_170.41.0el9.x86_64pigsty26.8 KiBsemver_17-0.41.0-1PIGSTY.el9.x86_64.rpm
semver_170.41.0el9.x86_64pgdg27.1 KiBsemver_17-0.41.0-1PGDG.rhel9.7.x86_64.rpm
semver_170.32.1el9.x86_64pgdg26.5 KiBsemver_17-0.32.1-1PGDG.rhel9.x86_64.rpm
semver_170.41.0el9.aarch64pigsty26.6 KiBsemver_17-0.41.0-1PIGSTY.el9.aarch64.rpm
semver_170.41.0el9.aarch64pgdg26.8 KiBsemver_17-0.41.0-1PGDG.rhel9.7.aarch64.rpm
semver_170.32.1el9.aarch64pgdg26.1 KiBsemver_17-0.32.1-1PGDG.rhel9.aarch64.rpm
semver_170.41.0el10.x86_64pigsty26.9 KiBsemver_17-0.41.0-1PIGSTY.el10.x86_64.rpm
semver_170.41.0el10.x86_64pgdg27.3 KiBsemver_17-0.41.0-1PGDG.rhel10.1.x86_64.rpm
semver_170.40.0el10.x86_64pgdg27.4 KiBsemver_17-0.40.0-1PGDG.rhel10.x86_64.rpm
semver_170.41.0el10.aarch64pigsty27.1 KiBsemver_17-0.41.0-1PIGSTY.el10.aarch64.rpm
semver_170.41.0el10.aarch64pgdg27.3 KiBsemver_17-0.41.0-1PGDG.rhel10.1.aarch64.rpm
semver_170.40.0el10.aarch64pgdg27.4 KiBsemver_17-0.40.0-1PGDG.rhel10.aarch64.rpm
postgresql-17-semver0.41.0d12.x86_64pgdg38.9 KiBpostgresql-17-semver_0.41.0-1.pgdg12+1_amd64.deb
postgresql-17-semver0.41.0d12.aarch64pgdg38.3 KiBpostgresql-17-semver_0.41.0-1.pgdg12+1_arm64.deb
postgresql-17-semver0.41.0d13.x86_64pgdg38.5 KiBpostgresql-17-semver_0.41.0-1.pgdg13+1_amd64.deb
postgresql-17-semver0.41.0d13.aarch64pgdg38.6 KiBpostgresql-17-semver_0.41.0-1.pgdg13+1_arm64.deb
postgresql-17-semver0.41.0u22.x86_64pgdg39.2 KiBpostgresql-17-semver_0.41.0-1.pgdg22.04+1_amd64.deb
postgresql-17-semver0.41.0u22.aarch64pgdg38.7 KiBpostgresql-17-semver_0.41.0-1.pgdg22.04+1_arm64.deb
postgresql-17-semver0.41.0u24.x86_64pgdg38.5 KiBpostgresql-17-semver_0.41.0-1.pgdg24.04+1_amd64.deb
postgresql-17-semver0.41.0u24.aarch64pgdg38.4 KiBpostgresql-17-semver_0.41.0-1.pgdg24.04+1_arm64.deb
PackageVersionOSORGSIZEFile URL
semver_160.41.0el8.x86_64pigsty27.5 KiBsemver_16-0.41.0-1PIGSTY.el8.x86_64.rpm
semver_160.41.0el8.x86_64pgdg28.4 KiBsemver_16-0.41.0-1PGDG.rhel8.10.x86_64.rpm
semver_160.32.1el8.x86_64pgdg27.1 KiBsemver_16-0.32.1-1PGDG.rhel8.x86_64.rpm
semver_160.41.0el8.aarch64pigsty27.2 KiBsemver_16-0.41.0-1PIGSTY.el8.aarch64.rpm
semver_160.41.0el8.aarch64pgdg28.0 KiBsemver_16-0.41.0-1PGDG.rhel8.10.aarch64.rpm
semver_160.32.1el8.aarch64pgdg26.8 KiBsemver_16-0.32.1-1PGDG.rhel8.aarch64.rpm
semver_160.41.0el9.x86_64pigsty26.8 KiBsemver_16-0.41.0-1PIGSTY.el9.x86_64.rpm
semver_160.41.0el9.x86_64pgdg27.1 KiBsemver_16-0.41.0-1PGDG.rhel9.7.x86_64.rpm
semver_160.32.1el9.x86_64pgdg26.3 KiBsemver_16-0.32.1-1PGDG.rhel9.x86_64.rpm
semver_160.41.0el9.aarch64pigsty26.6 KiBsemver_16-0.41.0-1PIGSTY.el9.aarch64.rpm
semver_160.41.0el9.aarch64pgdg26.8 KiBsemver_16-0.41.0-1PGDG.rhel9.7.aarch64.rpm
semver_160.32.1el9.aarch64pgdg25.8 KiBsemver_16-0.32.1-1PGDG.rhel9.aarch64.rpm
semver_160.41.0el10.x86_64pigsty26.9 KiBsemver_16-0.41.0-1PIGSTY.el10.x86_64.rpm
semver_160.41.0el10.x86_64pgdg27.3 KiBsemver_16-0.41.0-1PGDG.rhel10.1.x86_64.rpm
semver_160.40.0el10.x86_64pgdg27.4 KiBsemver_16-0.40.0-1PGDG.rhel10.x86_64.rpm
semver_160.41.0el10.aarch64pigsty27.2 KiBsemver_16-0.41.0-1PIGSTY.el10.aarch64.rpm
semver_160.41.0el10.aarch64pgdg27.3 KiBsemver_16-0.41.0-1PGDG.rhel10.1.aarch64.rpm
semver_160.40.0el10.aarch64pgdg27.4 KiBsemver_16-0.40.0-1PGDG.rhel10.aarch64.rpm
postgresql-16-semver0.41.0d12.x86_64pgdg38.9 KiBpostgresql-16-semver_0.41.0-1.pgdg12+1_amd64.deb
postgresql-16-semver0.41.0d12.aarch64pgdg38.3 KiBpostgresql-16-semver_0.41.0-1.pgdg12+1_arm64.deb
postgresql-16-semver0.41.0d13.x86_64pgdg38.5 KiBpostgresql-16-semver_0.41.0-1.pgdg13+1_amd64.deb
postgresql-16-semver0.41.0d13.aarch64pgdg38.6 KiBpostgresql-16-semver_0.41.0-1.pgdg13+1_arm64.deb
postgresql-16-semver0.41.0u22.x86_64pgdg39.2 KiBpostgresql-16-semver_0.41.0-1.pgdg22.04+1_amd64.deb
postgresql-16-semver0.41.0u22.aarch64pgdg38.8 KiBpostgresql-16-semver_0.41.0-1.pgdg22.04+1_arm64.deb
postgresql-16-semver0.41.0u24.x86_64pgdg38.5 KiBpostgresql-16-semver_0.41.0-1.pgdg24.04+1_amd64.deb
postgresql-16-semver0.41.0u24.aarch64pgdg38.4 KiBpostgresql-16-semver_0.41.0-1.pgdg24.04+1_arm64.deb
PackageVersionOSORGSIZEFile URL
semver_150.41.0el8.x86_64pigsty27.6 KiBsemver_15-0.41.0-1PIGSTY.el8.x86_64.rpm
semver_150.41.0el8.x86_64pgdg28.5 KiBsemver_15-0.41.0-1PGDG.rhel8.10.x86_64.rpm
semver_150.32.1el8.x86_64pgdg27.3 KiBsemver_15-0.32.1-1PGDG.rhel8.x86_64.rpm
semver_150.32.0el8.x86_64pgdg41.9 KiBsemver_15-0.32.0-1.rhel8.x86_64.rpm
semver_150.31.2el8.x86_64pgdg40.1 KiBsemver_15-0.31.2-1.rhel8.x86_64.rpm
semver_150.41.0el8.aarch64pigsty27.3 KiBsemver_15-0.41.0-1PIGSTY.el8.aarch64.rpm
semver_150.41.0el8.aarch64pgdg28.1 KiBsemver_15-0.41.0-1PGDG.rhel8.10.aarch64.rpm
semver_150.32.1el8.aarch64pgdg26.9 KiBsemver_15-0.32.1-1PGDG.rhel8.aarch64.rpm
semver_150.32.0el8.aarch64pgdg41.3 KiBsemver_15-0.32.0-1.rhel8.aarch64.rpm
semver_150.41.0el9.x86_64pigsty27.2 KiBsemver_15-0.41.0-1PIGSTY.el9.x86_64.rpm
semver_150.41.0el9.x86_64pgdg27.5 KiBsemver_15-0.41.0-1PGDG.rhel9.7.x86_64.rpm
semver_150.32.1el9.x86_64pgdg26.7 KiBsemver_15-0.32.1-1PGDG.rhel9.x86_64.rpm
semver_150.32.0el9.x86_64pgdg42.4 KiBsemver_15-0.32.0-1.rhel9.x86_64.rpm
semver_150.31.2el9.x86_64pgdg40.9 KiBsemver_15-0.31.2-1.rhel9.x86_64.rpm
semver_150.41.0el9.aarch64pigsty27.0 KiBsemver_15-0.41.0-1PIGSTY.el9.aarch64.rpm
semver_150.41.0el9.aarch64pgdg27.1 KiBsemver_15-0.41.0-1PGDG.rhel9.7.aarch64.rpm
semver_150.32.1el9.aarch64pgdg26.1 KiBsemver_15-0.32.1-1PGDG.rhel9.aarch64.rpm
semver_150.32.0el9.aarch64pgdg41.6 KiBsemver_15-0.32.0-1.rhel9.aarch64.rpm
semver_150.41.0el10.x86_64pigsty27.4 KiBsemver_15-0.41.0-1PIGSTY.el10.x86_64.rpm
semver_150.41.0el10.x86_64pgdg27.8 KiBsemver_15-0.41.0-1PGDG.rhel10.1.x86_64.rpm
semver_150.40.0el10.x86_64pgdg27.8 KiBsemver_15-0.40.0-1PGDG.rhel10.x86_64.rpm
semver_150.41.0el10.aarch64pigsty27.5 KiBsemver_15-0.41.0-1PIGSTY.el10.aarch64.rpm
semver_150.41.0el10.aarch64pgdg27.7 KiBsemver_15-0.41.0-1PGDG.rhel10.1.aarch64.rpm
semver_150.40.0el10.aarch64pgdg27.7 KiBsemver_15-0.40.0-1PGDG.rhel10.aarch64.rpm
postgresql-15-semver0.41.0d12.x86_64pgdg38.9 KiBpostgresql-15-semver_0.41.0-1.pgdg12+1_amd64.deb
postgresql-15-semver0.41.0d12.aarch64pgdg38.3 KiBpostgresql-15-semver_0.41.0-1.pgdg12+1_arm64.deb
postgresql-15-semver0.41.0d13.x86_64pgdg38.5 KiBpostgresql-15-semver_0.41.0-1.pgdg13+1_amd64.deb
postgresql-15-semver0.41.0d13.aarch64pgdg38.6 KiBpostgresql-15-semver_0.41.0-1.pgdg13+1_arm64.deb
postgresql-15-semver0.41.0u22.x86_64pgdg39.4 KiBpostgresql-15-semver_0.41.0-1.pgdg22.04+1_amd64.deb
postgresql-15-semver0.41.0u22.aarch64pgdg38.9 KiBpostgresql-15-semver_0.41.0-1.pgdg22.04+1_arm64.deb
postgresql-15-semver0.41.0u24.x86_64pgdg38.9 KiBpostgresql-15-semver_0.41.0-1.pgdg24.04+1_amd64.deb
postgresql-15-semver0.41.0u24.aarch64pgdg38.4 KiBpostgresql-15-semver_0.41.0-1.pgdg24.04+1_arm64.deb
PackageVersionOSORGSIZEFile URL
semver_140.41.0el8.x86_64pigsty27.6 KiBsemver_14-0.41.0-1PIGSTY.el8.x86_64.rpm
semver_140.41.0el8.x86_64pgdg28.5 KiBsemver_14-0.41.0-1PGDG.rhel8.10.x86_64.rpm
semver_140.32.1el8.x86_64pgdg27.3 KiBsemver_14-0.32.1-1PGDG.rhel8.x86_64.rpm
semver_140.32.0el8.x86_64pgdg41.9 KiBsemver_14-0.32.0-1.rhel8.x86_64.rpm
semver_140.31.2el8.x86_64pgdg40.4 KiBsemver_14-0.31.2-1.rhel8.x86_64.rpm
semver_140.31.1el8.x86_64pgdg39.8 KiBsemver_14-0.31.1-2.rhel8.x86_64.rpm
semver_140.41.0el8.aarch64pigsty27.3 KiBsemver_14-0.41.0-1PIGSTY.el8.aarch64.rpm
semver_140.41.0el8.aarch64pgdg28.1 KiBsemver_14-0.41.0-1PGDG.rhel8.10.aarch64.rpm
semver_140.32.1el8.aarch64pgdg26.9 KiBsemver_14-0.32.1-1PGDG.rhel8.aarch64.rpm
semver_140.32.0el8.aarch64pgdg41.4 KiBsemver_14-0.32.0-1.rhel8.aarch64.rpm
semver_140.41.0el9.x86_64pigsty27.2 KiBsemver_14-0.41.0-1PIGSTY.el9.x86_64.rpm
semver_140.41.0el9.x86_64pgdg27.5 KiBsemver_14-0.41.0-1PGDG.rhel9.7.x86_64.rpm
semver_140.32.1el9.x86_64pgdg26.7 KiBsemver_14-0.32.1-1PGDG.rhel9.x86_64.rpm
semver_140.32.0el9.x86_64pgdg42.4 KiBsemver_14-0.32.0-1.rhel9.x86_64.rpm
semver_140.41.0el9.aarch64pigsty27.0 KiBsemver_14-0.41.0-1PIGSTY.el9.aarch64.rpm
semver_140.41.0el9.aarch64pgdg27.1 KiBsemver_14-0.41.0-1PGDG.rhel9.7.aarch64.rpm
semver_140.32.1el9.aarch64pgdg26.0 KiBsemver_14-0.32.1-1PGDG.rhel9.aarch64.rpm
semver_140.32.0el9.aarch64pgdg41.6 KiBsemver_14-0.32.0-1.rhel9.aarch64.rpm
semver_140.41.0el10.x86_64pigsty27.4 KiBsemver_14-0.41.0-1PIGSTY.el10.x86_64.rpm
semver_140.41.0el10.x86_64pgdg27.7 KiBsemver_14-0.41.0-1PGDG.rhel10.1.x86_64.rpm
semver_140.40.0el10.x86_64pgdg27.8 KiBsemver_14-0.40.0-1PGDG.rhel10.x86_64.rpm
semver_140.41.0el10.aarch64pigsty27.5 KiBsemver_14-0.41.0-1PIGSTY.el10.aarch64.rpm
semver_140.41.0el10.aarch64pgdg27.6 KiBsemver_14-0.41.0-1PGDG.rhel10.1.aarch64.rpm
semver_140.40.0el10.aarch64pgdg27.7 KiBsemver_14-0.40.0-1PGDG.rhel10.aarch64.rpm
postgresql-14-semver0.41.0d12.x86_64pgdg38.9 KiBpostgresql-14-semver_0.41.0-1.pgdg12+1_amd64.deb
postgresql-14-semver0.41.0d12.aarch64pgdg38.3 KiBpostgresql-14-semver_0.41.0-1.pgdg12+1_arm64.deb
postgresql-14-semver0.41.0d13.x86_64pgdg38.6 KiBpostgresql-14-semver_0.41.0-1.pgdg13+1_amd64.deb
postgresql-14-semver0.41.0d13.aarch64pgdg38.6 KiBpostgresql-14-semver_0.41.0-1.pgdg13+1_arm64.deb
postgresql-14-semver0.41.0u22.x86_64pgdg39.4 KiBpostgresql-14-semver_0.41.0-1.pgdg22.04+1_amd64.deb
postgresql-14-semver0.41.0u22.aarch64pgdg38.9 KiBpostgresql-14-semver_0.41.0-1.pgdg22.04+1_arm64.deb
postgresql-14-semver0.41.0u24.x86_64pgdg38.9 KiBpostgresql-14-semver_0.41.0-1.pgdg24.04+1_amd64.deb
postgresql-14-semver0.41.0u24.aarch64pgdg38.4 KiBpostgresql-14-semver_0.41.0-1.pgdg24.04+1_arm64.deb

Source

pig build pkg pg_semver;		# build rpm

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

semver: semantic versioning data type

The semver extension provides a data type implementing Semantic Versioning 2.0.0.

CREATE EXTENSION semver;

SELECT '1.2.1'::semver;
SELECT '1.2.0'::semver > '1.2.0-b1'::semver;  -- true (prerelease < release)

Operators

OperatorDescriptionExampleResult
=Equal'1.2.0'::semver = '1.2.00'::semvert
<>Not equal'1.2.0'::semver <> '1.2.00'::semverf
<Less than'3.4.0-b1'::semver < '3.4.0'::semvert
<=Less or equal'3.4.0-b1'::semver <= '3.4.0'::semvert
>Greater than'3.4.0-b1'::semver > '3.4.0'::semverf
>=Greater or equal'3.4.0-b1'::semver >= '3.4.0'::semverf

Functions

FunctionDescriptionExampleResult
to_semver(text)Permissive parseto_semver('1.0')1.0.0
is_semver(text)Validate formatis_semver('1.2.0')true
semver(text)Strict castsemver('1.2.1')1.2.1
get_semver_major(semver)Major versionget_semver_major('4.2.0')4
get_semver_minor(semver)Minor versionget_semver_minor('4.2.0')2
get_semver_patch(semver)Patch versionget_semver_patch('4.2.0')0
get_semver_prerelease(semver)Prerelease partget_semver_prerelease('2.1.0-b2+bfb13')b2

Supports casts from text, numeric, real, double precision, integer, bigint, smallint.

Range Type

The semverrange type supports standard range operators:

SELECT '1.0.5'::semver <@ '[1.0.0, 2.0.0)'::semverrange;  -- true

Aggregate Functions

MIN(semver) and MAX(semver) are supported. Btree and hash indexes are available.

Last updated on