From: Martin Marques <martin@bugs.unl.edu.ar>
To: aspire420@hotpop.com, Sai Hertz And Control Systems <sank89@sancharnet.in>
Cc: aspire420@hotpop.com
Cc: pgsql-admin@postgresql.org
Cc: pgsql-sql@postgresql.org
Subject: Re: Anti log in PostgreSQL
Date: Fri, 26 Dec 2003 20:20:23 -0300
Message-ID: <200312262020.23940.martin@bugs.unl.edu.ar> (raw)
In-Reply-To: <3FECBA50.2000500@sancharnet.in>
References: <3FECB238.1050801@sancharnet.in>
<200312261934.35070.martin@bugs.unl.edu.ar>
<3FECBA50.2000500@sancharnet.in>
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
-----------------------------------------------------------------
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: martin@bugs.unl.edu.ar, sank89@sancharnet.in, aspire420@hotpop.com, pgsql-admin@postgresql.org
Subject: Re: Anti log in PostgreSQL
In-Reply-To: <200312262020.23940.martin@bugs.unl.edu.ar>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox