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

From Yasir Malik
Subject Re: Anti log in PostgreSQL
Date
Msg-id Pine.LNX.4.58.0312261813480.26722@heineken.cs.stevens-tech.edu
Whole thread Raw
In response to Re: Anti log in PostgreSQL  (Martin Marques <martin@bugs.unl.edu.ar>)
List pgsql-sql
The antilog of x is 10^x, so all you need to do is used the ^ operator.
If you are doing the antilog for some other base, there is formula to do
that as well, but I'm forgetting it.
Regards,
Yasir

On Fri, 26 Dec 2003, Martin Marques wrote:

> Date: Fri, 26 Dec 2003 19:34:35 -0300
> From: Martin Marques <martin@bugs.unl.edu.ar>
> To: aspire420@hotpop.com,
>      Sai Hertz And Control Systems <sank89@sancharnet.in>,
>      pgsql-admin@postgresql.org
> Cc: pgsql-sql@postgresql.org
> Subject: Re: [SQL] Anti log in PostgreSQL
>
i> El Vie 26 Dic 2003 19:12, Sai Hertz And Control Systems escribi�:
> > Dear all ,
> >
> > In one of our project I require to calculate antilog of  (3.3234)
> > But I could not find any functions in Documentation for the same.
> >
> > 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 ^.
>
> --
> 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
> -----------------------------------------------------------------
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: if posting/reading through Usenet, please send an appropriate
>       subscribe-nomail command to majordomo@postgresql.org so that your
>       message can get through to the mailing list cleanly
>


pgsql-sql by date:

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