From: Martin Marques <martin@bugs.unl.edu.ar>
To: aspire420@hotpop.com, Sai Hertz And Control Systems <sank89@sancharnet.in>
Subject: Re: Anti log in PostgreSQL
Date: Fri, 26 Dec 2003 20:20:23 -0300
User-Agent: KMail/1.5.4
Cc: aspire420@hotpop.com, pgsql-admin@postgresql.org, pgsql-sql@postgresql.org
References: <3FECB238.1050801@sancharnet.in>
	<200312261934.35070.martin@bugs.unl.edu.ar>
	<3FECBA50.2000500@sancharnet.in>
In-Reply-To: <3FECBA50.2000500@sancharnet.in>
MIME-Version: 1.0
Content-Type: text/plain;
  charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline
Message-Id: <200312262020.23940.martin@bugs.unl.edu.ar>

El Vie 26 Dic 2003 19:46, Sai Hertz And Control Systems escribi=F3:
> Dear Martin Marques ,
>=20
> >>In mathematics I would have written it something like
> >>
> >>A =3D antilog (3=B73234) =3D 2144
> >>=20=20=20=20
> >>
> >
> >As I can understand, this is a 10 base log, so that what you want is=20
> >10^(3.3234)?
> >
> >For that you have the exponential operator ^.
> >=20=20
> >
> Nope
> select exp(3.3234) as a2144
> Gives me
> 27.754555808589792
> But the answer expected is=20
> some what near to 2144
> The log tables show this

As I said, log10, not natural logaritm

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

Octave gives me this:

octave:1> 10^3.3234
ans =3D 2105.7

What is 2144?

--=20
select 'mmarques' || '@' || 'unl.edu.ar' AS email;
-----------------------------------------------------------------
Mart=EDn Marqu=E9s                  |        mmarques@unl.edu.ar
Programador, Administrador, DBA |       Centro de Telem=E1tica
                       Universidad Nacional
                            del Litoral
-----------------------------------------------------------------