Raw Package Information
Package: postgresql-17-debversion
Source: postgresql-debversion
Version: 1.2.0-2.pgdg20.04+4
Architecture: amd64
Maintainer: Debian PostgreSQL Maintainers <team+postgresql@tracker.debian.org>
Installed-Size: 67
Depends: postgresql-17, postgresql-17-jit-llvm (>= 10), libapt-pkg6.0 (>= 0.8.0), libc6 (>= 2.2.5)
Homepage: https://salsa.debian.org/postgresql/postgresql-debversion
Priority: optional
Section: database
Filename: pool/main/p/postgresql-debversion/postgresql-17-debversion_1.2.0-2.pgdg20.04+4_amd64.deb
Size: 16856
SHA256: 55c030c1725398aa51acfbedb955aafedfd342e6377808b6299bf795d81fad11
SHA1: 8c3b9cf5219e01d5a6670e8f5d1563d10b8d94cd
MD5sum: 2fd19fec0860cb4d89b28ffe312ee7b2
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()