Re: Anti log in PostgreSQL

Поиск
Список
Период
Сортировка
От Martin Marques
Тема Re: Anti log in PostgreSQL
Дата
Msg-id 200312262020.23940.martin@bugs.unl.edu.ar
обсуждение исходный текст
Ответ на Re: Anti log in PostgreSQL  (Sai Hertz And Control Systems <sank89@sancharnet.in>)
Список pgsql-sql
El Vie 26 Dic 2003 19:46, Sai Hertz And Control Systems escribió:
> Dear Martin Marques ,
>
> >>In mathematics I would have written it something like
> >>
> >>A = antilog (3·3234) = 2144
> >>
> >>
> >
> >As I can understand, this is a 10 base log, so that what you want is
> >10^(3.3234)?
> >
> >For that you have the exponential operator ^.
> >
> >
> Nope
> select exp(3.3234) as a2144
> Gives me
> 27.754555808589792
> But the answer expected is
> some what near to 2144
> The log tables show this

As I said, log10, not natural logaritm

prueba=> select 10^3.3234 AS res;      res
------------------2105.71698391175
(1 row)

Octave gives me this:

octave:1> 10^3.3234
ans = 2105.7

What is 2144?

--
select 'mmarques' || '@' || 'unl.edu.ar' AS email;
-----------------------------------------------------------------
Martín Marqués                  |        mmarques@unl.edu.ar
Programador, Administrador, DBA |       Centro de Telemática                      Universidad Nacional
        del Litoral 
-----------------------------------------------------------------



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

Предыдущее
От: Wei Weng
Дата:
Сообщение: Re: Anti log in PostgreSQL
Следующее
От: Sai Hertz And Control Systems
Дата:
Сообщение: Re: Anti log in PostgreSQL