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
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 |