postgresql-unit 3 released

Christoph Berg <[email protected]>
Newsgroups gmane.comp.db.postgresql.announce
Message-ID <[email protected]>
postgresql-unit 3 released
--------------------------

The PostgreSQL "unit" extension provides a datatype for values using
the SI base types, and Bytes.

Highlight in version 3 of the extension is the ability to define new
prefixes and units at run-time using database tables, and the vast
number of predefined prefixes and units imported from the GNU "unit"
tool. Over 2400 units are available now.


Example for a user-defined unit:

# INSERT INTO unit_units VALUES ('legobrick', '9.6 mm');
# SELECT '1 m'::unit @ 'legobricks' AS one_meter;
          one_meter
-----------------------------
 104.166666666667 legobricks


Changelog:

* 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
  hash_create(HASH_BLOBS).
* Bump license to GPL-3+ to match GNU units' license.


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


Christoph
-- 
Senior Berater, Tel.: +49 2166 9901 187
credativ GmbH, HRB Mönchengladbach 12080, USt-ID-Nummer: DE204566209
Trompeterallee 108, 41189 Mönchengladbach
Geschäftsführung: Dr. Michael Meskes, Jörg Folz, Sascha Heuer
pgp fingerprint: 5C48 FE61 57F4 9179 5970  87C6 4C5A 6BAB 12D2 A7AE
signature.asc (application/pgp-signature, 833 B)
-----BEGIN PGP SIGNATURE-----

iQIzBAABCAAdFiEEXEj+YVf0kXlZcIfGTFprqxLSp64FAljT0v0ACgkQTFprqxLS
p64J3w//YYBvolKbiFRkDxwXlR7m1wseyRuIZb9mZKqRg3zp4mnN/wOFNi+MNhyK
DYH4kGTxWS2mwLckKGba6sNd74sgc3DtXdde4ypk/5a3MTEbTeR7qVAxkjVqGzt1
n95zN5yb8kpQU+87IHIB9pTVFsewfVrW8EvSlVjplk9zLBbT1u9yX6iQnAeaCXNT
Ld1u9jaIIXl1IT2TttccDjEddt/lQ4wXftaIUyu1YeY8cuiFojN3NvSlSewIVQfS
wtSX/+zx24u6/GX1L3YDxFW3yVsAEPGgfqP5JoMEDA0Bcyy5mqzq/rWCfxf2gX0k
itdst/HcgtL7d7HPykSFVlrWX0Q7sssRUPOw/taIA0+aLvhj1vDxaFOzuhzchSUI
IAz3s6Tc/gom8bvprGfayeCy2BlD1itBhrcun8yI71TRXDIgIoP2zliVZV77sIFX
+V1x+Munkao8OdiBEsP9+yXYyti/EpS9TnjmlsJ3mdIBR9AIfuoay8HwXp67/5g6
WKUkmPvAiSHpicRjgg+Ec8IT0m9n0EuUEGl4ICXDbiipAGLuacsV6bLaYoMaGshj
XpstI/YiYKWj4x972FTQIZWd/rYDq9x5vpHKLyMhx4TBGElKFZMWlfBdr95NnOeM
TwrOXt7Snru0gcW62r5561lVYl76Abaq3Y88SL9cEPvRCtE9BkM=
=2rIs
-----END PGP SIGNATURE-----
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.