postgresql-10-debversion - Debian version number type for PostgreSQL

Property Value
Distribution Ubuntu 18.04 LTS (Bionic Beaver)
Repository Ubuntu Universe i386
Package filename postgresql-10-debversion_1.1-1_i386.deb
Package name postgresql-10-debversion
Package version 1.1
Package release 1
Package architecture i386
Package type deb
Category universe/database
Homepage -
License -
Maintainer Ubuntu Developers <>
Download size 9.20 KB
Installed size 46.00 KB
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()


Package Version Architecture Repository
postgresql-10-debversion_1.1-1_amd64.deb 1.1 amd64 Ubuntu Universe
postgresql-10-debversion - - -


Name Value
libapt-pkg5.0 >= 0.8.0
libc6 >= 2.1.3
libstdc++6 >= 4.1.1
postgresql-10 -


Type URL
Binary Package postgresql-10-debversion_1.1-1_i386.deb
Source Package postgresql-debversion

Install Howto

  1. Update the package index:
    # sudo apt-get update
  2. Install postgresql-10-debversion deb package:
    # sudo apt-get install postgresql-10-debversion




2017-11-17 - Christoph Berg <>
postgresql-debversion (1.1-1) unstable; urgency=medium
* Switch to plain pgxs buildsystem.
* Add selectivity estimators to comparison operators.
* Move packaging repository to pkg-postgresql.
2017-09-27 - Christoph Berg <>
postgresql-debversion (1.0.8-3) unstable; urgency=medium
* Upload with PostgreSQL 10 support. Closes: #876506.
* Set source format to 1.0 to ease snapshot builds.
* Set Debian PostgreSQL team as Maintainer.
* Remove Roger and Francesco from Uploaders, thanks for your work!
Closes: #869349.
2016-09-24 - Christoph Berg <>
postgresql-debversion (1.0.8-2) unstable; urgency=medium
* Upload with 9.6 support.
2016-02-03 - Christoph Berg <>
postgresql-debversion (1.0.8-1) unstable; urgency=medium
[ Roger Leigh ]
* New upstream release.
* Extension support is now required, meaning PostgreSQL 9.1
and later.
[ Christoph Berg ]
* Use 3.0 (quilt) format.
* debian/rules: Install NEWS as upstream changelog.
* Invoke regression tests from debian/tests/installcheck.
* Move Vcs headers to https.
* Add myself to Uploaders.
2014-08-09 - Roger Leigh <>
postgresql-debversion (1.0.7-4) unstable; urgency=low
* debian/rules, debian/
- Build for multiple PostgreSQL versions using
postgresql-server-dev-all (Closes: #725795).  Thanks to
Christoph Berg for this patch.
- Upgrade to Standards-Version 3.9.3 (no changes).
- Use dh-autoreconf (Closes: #732925).  Thanks to Logan Rosen
for this patch.
* Drop support for postgresql 9.3, replaced by support for 9.4
(Closes: #757335).
2013-09-09 - Roger Leigh <>
postgresql-debversion (1.0.7-3) unstable; urgency=low
* Drop support for postgresql 9.1 and 9.2, now 9.3 is in unstable.
* debian/control:
- Drop Build-Depends on postgresql-server-dev-9.1 and
- Drop postgresql-9.1-debversion and postgresql-9.2-debversion
* debian/rules:
- Don't build 9.1 and 9.2 versions of the library.
2013-05-20 - Roger Leigh <>
postgresql-debversion (1.0.7-2) experimental; urgency=low
* Add support for postgresql 9.3.
* debian/control:
- Build-Depend on postgresql-server-dev-9.3.
- Upgrade to Standards-Version 3.9.3 (no changes).
- Add postgresql-9.3-debversion.
* debian/rules:
- Build 9.1, 9.2 and 9.3 versions of the library.
2012-08-29 - Roger Leigh <>
postgresql-debversion (1.0.7-1) experimental; urgency=low
* New upstream release.
* Add support for postgresql 9.2.
* debian/control:
- Build-Depend on debhelper v9 and postgresql-server-dev-9.2.
- Upgrade to Standards-Version 3.9.3 (no changes).
- Add postgresql-9.2-debversion.
* debian/compat: Use debhelper v9.
* debian/rules:
- Build 9.1 and 9.2 versions of the library.
2011-08-26 - Roger Leigh <>
postgresql-debversion (1.0.6-1) unstable; urgency=low
* New upstream release.
* Add support for postgresql 9.1.
* Enable extension support for postgresql-9.1
* debian/control:
- Build-Depend on postgresql-server-dev-9.1.
- Remove Build-Depends on postgresql-server-dev-8.4 and
- Add postgresql-9.1-debversion.
- Upgrade to Standards-Version 3.9.2.
- Require debhelper >> 8.9.6 and autotools-dev for dh v9
* debian/rules:
- Build 9.0 and 9.1 versions of the library.  8.4 and 9.0 are no
longer supported.
- Build with debhelper's dh with compat level 9.
2010-11-17 - Roger Leigh <>
postgresql-debversion (1.0.4-1) unstable; urgency=low
* New upstream release.
* configure check for libapt_pkg uses LIBS rather than LDFLAGS for
specifying libraries to link.  Thanks to Michael Vogt for this

See Also

Package Description
postgresql-10-dirtyread_1.3_i386.deb Read dead but unvacuumed tuples from a PostgreSQL relation
postgresql-10-ip4r_2.2-2_i386.deb IPv4 and IPv6 types for PostgreSQL 10
postgresql-10-jsquery_1.0.1-1_i386.deb PostgreSQL JSON query language with GIN indexing support
postgresql-10-mimeo_1.5.1-2_all.deb specialized, per-table replication between PostgreSQL instances
postgresql-10-mysql-fdw_2.3.0-2_i386.deb Postgres 10 Foreign Data Wrapper for MySQL
postgresql-10-ogr-fdw_1.0.5-2_i386.deb PostgreSQL foreign data wrapper for OGR
postgresql-10-orafce_3.6.1-1_i386.deb Oracle support functions for PostgreSQL 10
postgresql-10-partman_3.1.2-1_i386.deb PostgreSQL Partition Manager
postgresql-10-pgaudit_1.2.0-1_i386.deb PostgreSQL Audit Extension
postgresql-10-pgextwlist_1.6-1_i386.deb PostgreSQL Extension Whitelisting
postgresql-10-pgfincore_1.2.1-1_i386.deb set of PostgreSQL functions to manage blocks in memory
postgresql-10-pglogical_2.1.1-1_i386.deb Logical Replication Extension for PostgreSQL
postgresql-10-pgmemcache_2.3.0-4_i386.deb PostgreSQL interface to memcached
postgresql-10-pgmp_1.0.2-5_i386.deb arbitrary precision integers and rationals for PostgreSQL 10
postgresql-10-pgq-node_3.2.5-1_all.deb Cascaded queueing on top of PgQ