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-----