postgresql-10-unit - SI Units for PostgreSQL

Property Value
Distribution Ubuntu 18.04 LTS (Bionic Beaver)
Repository Ubuntu Universe amd64
Package filename postgresql-10-unit_5.0-1_amd64.deb
Package name postgresql-10-unit
Package version 5.0
Package release 1
Package architecture amd64
Package type deb
Category universe/database
License -
Maintainer Ubuntu Developers <>
Download size 58.49 KB
Installed size 279.00 KB
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-10-unit_5.0-1_i386.deb 5.0 i386 Ubuntu Universe
postgresql-10-unit - - -


Name Value
libc6 >= 2.14
postgresql-10 -


Type URL
Binary Package postgresql-10-unit_5.0-1_amd64.deb
Source Package postgresql-unit

Install Howto

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




2018-01-10 - Christoph Berg <>
postgresql-unit (5.0-1) unstable; urgency=medium
* Add rounding function.
* Import definitions.units from GNU units 2.16 with 70 new units.
(The file header erroneously says 2.19.)
* debian/watch: Ignore debian/ tags.
2017-09-27 - Christoph Berg <>
postgresql-unit (4.0-2) unstable; urgency=medium
* Upload with PostgreSQL 10 support.
* Mark package as non-native and add watch file.
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_10+190_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-2_amd64.deb efficient PostgreSQL table content comparison and synchronization
postgresql-filedump_10.0-1build1_amd64.deb Utility to format PostgreSQL files
postgresql-hll_2.7-2.1_amd64.deb HyperLogLog extension for PostgreSQL
postgresql-pgsphere_1.1.1+2017.08.30-1build1_amd64.deb Spherical data types for PostgreSQL
postgresql-q3c_1.5.0-3build1_amd64.deb PostgreSQL extension used for indexing the sky
postgresql-server-dev-10_10.3-1_amd64.deb development files for PostgreSQL 10 server-side programming
postgresql-server-dev-all_190_all.deb extension build tool for multiple PostgreSQL versions
postgrey_1.36-5_all.deb greylisting implementation for Postfix
postmark_1.53-2_amd64.deb File system benchmark from NetApp
postnews_0.7-1_all.deb Usenet article postings via NNTP from the command line
postr_0.13.1-1_all.deb upload photos to Flickr
postsrsd_1.4-1_amd64.deb Sender Rewriting Scheme (SRS) lookup table for Postfix
potool_0.16-3_amd64.deb program to aid manipulation of gettext po files