postgresql-9.6-unit - SI Units for PostgreSQL

Property Value
Distribution Ubuntu 17.10 (Artful Aardvark)
Repository Ubuntu Universe i386
Package name postgresql-9.6-unit
Package version 4.0
Package architecture i386
Package type deb
Installed size 258 B
Download size 57.97 KB
Official Mirror
postgresql-unit implements a PostgreSQL datatype for SI units, plus byte. The
base units can be combined to named and unnamed derived units using operators
defined in the PostgreSQL type system. SI prefixes are used for input and
output, and quantities can be converted to arbitrary scale.


Package Version Architecture Repository
postgresql-9.6-unit_4.0_amd64.deb 4.0 amd64 Ubuntu Universe
postgresql-9.6-unit - - -


Name Value
libc6 >= 2.4
postgresql-9.6 -


Type URL
Binary Package postgresql-9.6-unit_4.0_i386.deb
Source Package postgresql-unit

Install Howto

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




2017-07-07 - Christoph Berg <>
postgresql-unit (4.0) unstable; urgency=medium
* Support exponents written using Unicode superscript characters.
* Report 22P02/invalid_text_representation on invalid unit input.
* Fix crash when unit_reset() runs into an OOM error. Patch by Andreas
Seltenreich, thanks!
* Change @ operator signature to (unit, text).
2017-03-23 - Christoph Berg <>
postgresql-unit (3.1) experimental; urgency=medium
* Reupload to Debian, the 3.0 tarball uploaded contained generated files
that broke out-of-tree builds. No source changes.
2017-03-22 - Christoph Berg <>
postgresql-unit (3.0) experimental; urgency=medium
* Support defining new units at runtime.
* Import unit definitions from GNU units.
* Add sqrt() and cbrt() functions.
* Extension is not relocatable after installation anymore.
* Bump extension version to 3.
* Bump minimum supported PostgreSQL version to 9.5 so we can use
* Bump license to GPL-3+ to match GNU units' license.
2017-01-09 - Christoph Berg <>
postgresql-unit (2.0) unstable; urgency=medium
* Support IEC binary prefixes for byte.
* Support United States customary units: in, ft, yd, mi, oz, lb.
* Add variance and stddev aggregates; bump extension version to 2.
2016-10-31 - Christoph Berg <>
postgresql-unit (1.1) unstable; urgency=medium
* Use float8out_internal to format floats on output.
2016-09-22 - Christoph Berg <>
postgresql-unit (1.0) unstable; urgency=medium
* Initial release.

See Also

Package Description
postgresql-all_9.6+184ubuntu1_all.deb metapackage depending on all PostgreSQL server packages
postgresql-autodoc_1.40-3_all.deb Utility to create a PostgreSQL database schema overview in HTML, DOT and XML
postgresql-comparator_2.3.0-1_i386.deb efficient PostgreSQL table content comparison and synchronization
postgresql-filedump_9.6.0-2_i386.deb Utility to format PostgreSQL files
postgresql-hll_2.7-2.1_i386.deb HyperLogLog extension for PostgreSQL
postgresql-mysql-fdw-doc_2.2.0-2_all.deb documentation for mysql-fdw
postgresql-plperl-9.6_9.6.5-1_i386.deb PL/Perl procedural language for PostgreSQL 9.6
postgresql-plpython-9.6_9.6.5-1_i386.deb PL/Python procedural language for PostgreSQL 9.6
postgresql-plpython3-9.6_9.6.5-1_i386.deb PL/Python 3 procedural language for PostgreSQL 9.6
postgresql-pltcl-9.6_9.6.5-1_i386.deb PL/Tcl procedural language for PostgreSQL 9.6
postgresql-server-dev-9.6_9.6.5-1_i386.deb development files for PostgreSQL 9.6 server-side programming
postgresql-server-dev-all_184ubuntu1_all.deb extension build tool for multiple PostgreSQL versions
postgrey_1.36-4_all.deb greylisting implementation for Postfix
postmark_1.53-2_i386.deb File system benchmark from NetApp
postnews_0.6.1-1_all.deb Post Usenet articles via NNTP from the command line