Re: Extended unit

From: Alban Hertroys <alban(at)magproductions(dot)nl>
To: Greg Stark <gsstark(at)mit(dot)edu>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Extended unit
Date: 2005-01-31 10:57:41
Message-ID: 41FE0F25.50706@magproductions.nl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Greg Stark wrote:
> You mean like the traditional units program available on virtually all Unix
> machines?
>
> $ units
> 2084 units, 71 prefixes, 32 nonlinear units
>
> You have: 1 lightyear/fortnight
> You want: m/s
> * 7.8213711e+09
> / 1.2785482e-10
>
> That's the program I suggested writing a function to hand this work off to
> (presumably in the form of a dynamic library). Keep the postgres code agnostic
> about the semantics of the units. As long as you stick to linear units then
> Postgres can treat them as opaque strings.

Except that it also says:

$ units
510 units, 54 prefixes
You have: 1 K
You want: degC
* 1
/ 1

Which is incorrect, of course. Same for degrees Fahrenheit. The poor
command can't do baseline offsets.

--
Alban Hertroys
MAG Productions

T: +31(0)53 4346874
F: +31(0)53 4346876
E: alban(at)magproductions(dot)nl
W: http://www.magproductions.nl

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Terry Lee Tucker 2005-01-31 11:01:25 Re: Prompt User From a pgplsql Function
Previous Message Alban Hertroys 2005-01-31 10:29:18 Re: postgres session termination