Re: [GENERAL] Unit conversion database (was: multiple paramters in aggregate function)

2009-08-20 Thread Karsten Hilbert
On Wed, Aug 19, 2009 at 08:31:17PM +0200, Alban Hertroys wrote: > He he, all right then! There certainly are some things left to > improve. One thing I noticed from the links you sent is that I > ignored a few units used in medicine assuming they were deprecated > ages ago - apparently not... Ah,

Re: [GENERAL] Unit conversion database (was: multiple paramters in aggregate function)

2009-08-19 Thread Alvaro Herrera
Alban Hertroys wrote: > >There's also a Debian package which comes with a text format > >units database: > > > > http://packages.debian.org/source/sid/units > > > >The original source for that: > > > >This package was put together by me, James Troup , > >from the GNU sources, which I obtained fro

Re: [GENERAL] Unit conversion database (was: multiple paramters in aggregate function)

2009-08-19 Thread Alban Hertroys
On 19 Aug 2009, at 19:20, Karsten Hilbert wrote: Alban, I think having an installable schema for units of measure with definitions and functions would be a great addition to PostgreSQL. Karsten, Thanks for the praise and the links. I for one know we would use it in GNUmed (wiki.gnumed.de).

Re: [GENERAL] Unit conversion database (was: multiple paramters in aggregate function)

2009-08-19 Thread Karsten Hilbert
Alban, I think having an installable schema for units of measure with definitions and functions would be a great addition to PostgreSQL. I for one know we would use it in GNUmed (wiki.gnumed.de). A few points: Would these guys be of use as a source for reference data ? http://unitsofmeasur

Re: [GENERAL] Unit conversion database (was: multiple paramters in aggregate function)

2009-08-19 Thread Alban Hertroys
On 18 Aug 2009, at 19:59, Alban Hertroys wrote: Hello all, Inspired by the original discussion on aggregating quantities of different units I made a start at a unit conversion database and the result is here: http://solfertje.student.utwente.nl/documents/units.sql I just uploaded an updat

Re: [GENERAL] Unit conversion database (was: multiple paramters in aggregate function)

2009-08-18 Thread Alban Hertroys
Hello all, Inspired by the original discussion on aggregating quantities of different units I made a start at a unit conversion database and the result is here: http://solfertje.student.utwente.nl/documents/units.sql This is not a complete implementation, I just thought I'd show you what