Source: postgresql-debversion Section: database Priority: optional Maintainer: Debian PostgreSQL Maintainers Uploaders: Michael Banck , Christoph Berg Build-Depends: debhelper (>= 9), libapt-pkg-dev, postgresql-server-dev-all Standards-Version: 4.1.1 Vcs-Browser: https://salsa.debian.org/postgresql/postgresql-debversion Vcs-Git: https://salsa.debian.org/postgresql/postgresql-debversion.git Package: postgresql-PGVERSION-debversion Architecture: any Depends: ${misc:Depends}, ${shlibs:Depends}, postgresql-PGVERSION 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()