Package: postgresql-12-debversion Source: postgresql-debversion Version: 1.1.2-1.pgdg18.04+1 Architecture: i386 Maintainer: Debian PostgreSQL Maintainers Installed-Size: 60 Depends: postgresql-12, libapt-pkg5.0 (>= 0.8.0), libc6 (>= 2.1.3) Priority: optional Section: database Filename: pool/main/p/postgresql-debversion/postgresql-12-debversion_1.1.2-1.pgdg18.04+1_i386.deb Size: 16248 SHA256: 7c66b7508271e8f9b1543e9e1058f55fac39b8cc8fcf9e6dbb2e712e9eb6b0b1 SHA1: 36e9bdc344cbe0a6fa2118d76664f0d6d0c7672c MD5sum: 0447ac8a942c2dc2532087152a5ebbad 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()