From: | Christoph Berg <christoph(dot)berg(at)credativ(dot)de> |
---|---|
To: | PostgreSQL Announce <pgsql-announce(at)postgresql(dot)org> |
Subject: | postgresql-unit 3 released |
Date: | 2017-03-23 13:51:58 |
Message-ID: | 20170323135158.akxosknjdljewuip@msg.credativ.de |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-announce pgsql-general |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Karsten Hilbert | 2017-03-23 15:28:03 | Re: [ANNOUNCE] postgresql-unit 3 released |
Previous Message | Britt Cole | 2017-03-22 09:01:48 | PGDay UK 2017 - Registration and CFP Open! |
From | Date | Subject | |
---|---|---|---|
Next Message | Poul Kristensen | 2017-03-23 14:12:30 | Checksum and Wal files |
Previous Message | Charles Clavadetscher | 2017-03-23 10:03:09 | Re: Wiki editor privilege |