Re: Extended unit

Поиск
Список
Период
Сортировка
От Alban Hertroys
Тема Re: Extended unit
Дата
Msg-id 41FE0F25.50706@magproductions.nl
обсуждение исходный текст
Ответ на Re: Extended unit  (Greg Stark <gsstark@mit.edu>)
Ответы Re: Extended unit
Список 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@magproductions.nl
W: http://www.magproductions.nl

В списке pgsql-general по дате отправления:

Предыдущее
От: Alban Hertroys
Дата:
Сообщение: Re: postgres session termination
Следующее
От: Terry Lee Tucker
Дата:
Сообщение: Re: Prompt User From a pgplsql Function