Package: postgresql-19-debversion Source: postgresql-debversion Version: 1.2.0-3.pgdg26.04+1 Architecture: amd64 Maintainer: Debian PostgreSQL Maintainers Installed-Size: 63 Depends: postgresql-19, libapt-pkg7.0 (>= 1.1~exp9), libc6 (>= 2.2.5) Breaks: postgresql-19-jit-llvm (<< 21) Homepage: https://salsa.debian.org/postgresql/postgresql-debversion Priority: optional Section: database Filename: pool/main/p/postgresql-debversion/postgresql-19-debversion_1.2.0-3.pgdg26.04+1_amd64.deb Size: 14080 SHA512: 69bf9260260c7f0201e87f9e7021acfd97bc2c4ee16e91bb2463cd6fda8efeb7ec7f84e912060032e79ba230f3e55e22cc0981a85442d6a0d806d3cd6a34d1b2 SHA256: 7abbf5edb5486b137e42b408e3b39c6446122339a07d7eb29e47fdbeae91d170 SHA1: 02a9caaeb88459b87a9d7b8304b7ae26f6656034 MD5sum: 2cda5ec97949381e6743b8b0d5ec3e69 Description: Debian version number type for PostgreSQL Debian version numbers, used to version Debian binary and source packages, have a defined format, including specifications for how versions should be compared in order to sort them. This package implements a "debversion" type to represent Debian version numbers within the PostgreSQL database. This also includes operators for version comparison and index operator classes for creating indexes on the debversion type. . Version comparison uses the algorithm used by the Debian package manager, dpkg, using the implementation from libapt-pkg. This means that columns in tables using the debversion type may be sorted and compared correctly using the same logic as "dpkg --compare-versions". It is also possible to create indexes on these columns. . postgresql-debversion implements the following features: . * The "debversion" type (internally derived from the "text" type) * A full set of operators for version comparison (< <= = <> >= >) including commutator and negator optimisation hints * Operator classes for btree and hash indexes * The aggregate functions min() and max()