postgresql-unit 3 released

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

Responses

Browse pgsql-announce by date

  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!

Browse pgsql-general by date

  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