postgresql-unit 3 released

Started by Christoph Bergabout 9 years ago2 messagesgeneral
Jump to latest
#1Christoph Berg
myon@debian.org

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

#2Karsten Hilbert
Karsten.Hilbert@gmx.net
In reply to: Christoph Berg (#1)
Re: [ANNOUNCE] postgresql-unit 3 released

On Thu, Mar 23, 2017 at 02:51:58PM +0100, Christoph Berg wrote:

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.

This is coming along really nicely !

May I ask whether UCUM has been considered for inclusion ? I
do realize this is large (as in LARGE) -- I am not asking for
something to be done, only for the current state of thinking
regarding this data source.

http://unitsofmeasure.org/trac

https://en.wikipedia.org/wiki/Unified_Code_for_Units_of_Measure

Thanks,
Karsten
--
GPG key ID E4071346 @ eu.pool.sks-keyservers.net
E167 67FD A291 2BEA 73BD 4537 78B9 A9F9 E407 1346

--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general