Re: Anti log in PostgreSQL

From: Martin Marques <martin(at)bugs(dot)unl(dot)edu(dot)ar>
To: aspire420(at)hotpop(dot)com, Sai Hertz And Control Systems <sank89(at)sancharnet(dot)in>
Cc: aspire420(at)hotpop(dot)com, pgsql-admin(at)postgresql(dot)org, pgsql-sql(at)postgresql(dot)org
Subject: Re: Anti log in PostgreSQL
Date: 2003-12-26 23:20:23
Message-ID: 200312262020.23940.martin@bugs.unl.edu.ar
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin 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(at)unl(dot)edu(dot)ar
Programador, Administrador, DBA | Centro de Telemática
Universidad Nacional
del Litoral
-----------------------------------------------------------------

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Sai Hertz And Control Systems 2003-12-26 23:25:11 Re: Anti log in PostgreSQL
Previous Message Yasir Malik 2003-12-26 23:18:56 Re: Anti log in PostgreSQL

Browse pgsql-sql by date

  From Date Subject
Next Message Sai Hertz And Control Systems 2003-12-26 23:25:11 Re: Anti log in PostgreSQL
Previous Message Yasir Malik 2003-12-26 23:18:56 Re: Anti log in PostgreSQL