postgresql-unit 2.0 released

postgresql-unit 2.0 released
----------------------------

Changes since 1.0:

  * 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.
  * Use float8out_internal to format floats on output.


New features screenshot
-----------------------

# SET unit.byte_output_iec = on;
# SELECT '4 TB'::unit AS disk_sold_as_4tb;
   disk_sold_as_4tb
----------------------
 3.63797880709171 TiB

# SELECT '500 mi'::unit AS walk_500_miles;
 walk_500_miles
----------------
 804.672 km


About postgresql-unit
---------------------

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. Byte quantities can also use IEC binary
prefixes for input and output.

Some non-SI units are supported, namely coherent derived units such as
newton and joule, non-coherent units such as hours  and litres, and
assorted United States customary units such as inch and mile.

Requires PostgreSQL 9.4 or later (uses psprintf()), flex, and bison 3
(the pre-built grammar files are used if only bison 2 is available).


Download
--------

https://github.com/ChristophBerg/postgresql-unit

Packages are available via Debian unstable/testing,
apt.postgresql.org, and yum.postgresql.org.

-----BEGIN PGP SIGNATURE-----

iQIzBAABCAAdFiEEXEj+YVf0kXlZcIfGTFprqxLSp64FAlh08sUACgkQTFprqxLS
p67KCQ//ZXKHvtbiZpNdSBDz1x+sC7OsG5wnhSmKMXimJrHmtfjeg+JRgAdvBO1S
N6uDPXKYZj4vB24R7clb8f249cBv/hBCyoaY6Wv1miAviSCg0cu1qI6OJMmvw/So
3zMZihN4PIFFu3jh2vxRcSvWDvor4XKSbpomihzIbOX+sDdacY95sNXucV3OFiKz
ze6hOSndB1VbgUiJQTS3UQJEAfodAVoQi4Jo3fDMvp1DtU1aol3crf/3sld8jKNr
3qBpywO/2Vy25iJqJpIxEshbvnbXldJTOyeUerCiCxYcuDM6tmfrx8AnT9N/3lin
m7ngSUc/ikN1K7H7HaMOuJWrTJM2SKU3n7qdC4tUmZ5j9QkA0xPcPczPFeWhl++z
F9HWzkLHo5oF/jX+xwqVPA9IZovimMNzyFMZ4nzdnSe7ltdCn9WKNJg0cJx/b5vn
LZuTlCDAeQiCVy5e6l8lqgYmBppU0iiN5eeFTd6GXdaAvJw4vFakQfJQWKOHZulp
juUyy3Z4vs6+v0K0pFA+khhw9R/YYJa6u6mZ88zCHtaLffSoyiYtlctPFevGYeak
/F/gZfrpMj0ilq5MB0ckd8DHc+tH6uXgxV50LzEdKXnwmpHQuNshdvbId8t4g99E
b69W4e7A40ThRFP8OyQzIlmmHv8RXtcIifS2lbj24eEmBy5gtZU=
=zbrd
-----END PGP SIGNATURE-----