Re: Anti log in PostgreSQL - Mailing list pgsql-sql

From Martin Marques
Subject Re: Anti log in PostgreSQL
Date
Msg-id 200312262020.23940.martin@bugs.unl.edu.ar
Whole thread Raw
In response to Re: Anti log in PostgreSQL  (Sai Hertz And Control Systems <sank89@sancharnet.in>)
List 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 by date:

Previous
From: Wei Weng
Date:
Subject: Re: Anti log in PostgreSQL
Next
From: Sai Hertz And Control Systems
Date:
Subject: Re: Anti log in PostgreSQL